help to change data on another table via relationship
This is probably something very easy, but can't get it to work.
I have 2 tables, one called timeline the other contingencies and they are joined by escrowid. I create a record on timeline and have a portal on this layout for contingencies where I use drop downs to choose the appropriate contingency and create/delete records in this portal as necessary. Relationship works fine, but if I enter the escrow number on the timeline layout and lets say I've added all these contingencies within the portal to then later find out I mistyped the escrow number and now need to change it, it doesn't reflect the change on the aleady created records in the contingency table. So, I'm trying to figure out how to change the escrowid field on timeline and have it update the already associated contingencies. I have to be careful in using scripts because I then sync this database with FMTouch and not all scripts are supported. Thanks for your help.