I am trying to figure out how to have 2 different tables with essentially the same column that updates in both places when a change is made.
See my example doc here; I want when I tag an asset in “marketing campaigns” for that change to be reflected on the asset table as well, and vice versa. When I tag an asset with a campaign in “marketing assets” I want that campaign to be updated with the appropriate asset.
I know how to display all the assets for a particular campaign with a filter, and I also know that if I change the view to card, I can add new rows to each table from within the details view.
But I cannot figure out how to make the current table view do what I want, ie be a lookup that can be changed from either table.
Is this possible? Does it need to be a view of the same table?