AnsweredAssumed Answered

If I alter a field, how can I get it to update the related field in another table?

Question asked by mikerevans on Jun 6, 2017
Latest reply on Jun 6, 2017 by philmodjunk



I have some reference numbers, and I have found that if entered incorrectly initially, they will need corrected. However I am unable them to update the related record in the other table.


I have created a script to be run after exit of the edit box:-



Set Field [Table1::Ref_No; Table2::Ref_No]


But it simply creates a new record without amending the existing.


(Edit: I can now see this is not the best way, as it commits a new record in the new table where it hasn't been created yet)


Please can you advise?


Thanks in advance.



Message was edited by: Mike Evans