I would like the ability to update all Select List contents when updating a column:row that is referenced.
For example, if I have an Ingredients table with three entries, and a Recipes table with a recipe that uses those ingredients:
If I change the name of one of the items (say I realize that I wrote Cumin but I meant to write Curry) then when I change the value in my original Ingredients table it breaks the Recipes table.
Now my Recipes table is broken, so I have to update the ingredient column in Curry Chicken Recipe Ingredients column.
If I made the mistake in many locations then I have a lot to fix. It would be nice if when the contents of the row is updated the table is automatically updated as well. Perhaps this could be done by referencing the row number rather than the actual ingredient name.
Note: This is obviously a bit of a contrived example, but work with me.
Another Note: I think the right way to do this would be to put it all in a single table (I seem to fail to do this every time) so I recognize that this could be my own shortcomings, not a Coda issue. But it is something that I run into fairly frequently, and it is a current pain-point that I have with several documents that I’ve built. Again, perhaps I could migrate all my columns into a single table and that would fix the issue, but for my current design methodology it’s problematic.