4 Replies Latest reply on Jun 6, 2017 10:45 AM by philmodjunk

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




      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