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.


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