I have database app that has a master table with several detail tables. The link is through the a field called "title".
When I edit this the title in the master table, how do I make it so that the change of title is reflected in the detail tables?
At the moment when I change the title in the master table, a new record is added in the detail tables rather than the old record being modified. This causes data associated with the old title to become "lost".