Edit Name and change across all data source with the same name

I am building a directory app. i have multiple department eg: A, B, C
Name x belongs to let say A and B
Now, when i edit the name of x in department A to xx or maybe add address field, i want the changes to take place automatically in department B.

Has anyone done this functionality or similar. I would be grateful if you could provide solution or suggestion.

It’s not good practice to use a name for a relation exactly for the reason to pointed out. Names can change. It’s better to have a RowID. Then you can store that RowID in other tables and use a relation and lookup to retrieve the name, address, etc. from the table that stores the name. That way everything is connected and dynamically charges everywhere if you change the name.

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.