Bulk update rows when a relation changes

[ndench]

I have a “group” table which just contains a name. My users can join a group, which stores the group name in a column on the users table and I have a relationship column based on that.

When someone edits a group name, I’d like to update the group column on every user that is in the group, so that they are still in the same group after the edit. Otherwise they would be in an invalid group.

Is this possible?

[david]

Add a Row ID to your Groups table and store that in the Users table to make the relation. Then you can change the names as much as you want!

[ndench]

Oh right, make the relation work on property that cannot be edited. That makes sense, thanks for the speedy reply!