I have a Properties table and a Contact table. I also have a relationship table that enable users to relate Contacts and Properties.
When a user updates a row in the ContactAndProperties (relationship) table. I want to give them the ability to make that same update across the entire table for all of that Contacts relationships. For example
Contact A is related to Property X, Property Y and Property Z.
If a user updates the interest column the relationship between Contact A and Property X to Active. I want them to then also have the option to update Contact A’s relationship with Property Y and Property Z to Active as well, if desired.
The reasoning here is so that if the user wants to make the same changes to all or some of the Contacts relationships they do not have to change each relationship individually.