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?

    mikerevans

      Hi,

       

      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:-

       

      OnObjectExit

      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.

      Mike

       

      Message was edited by: Mike Evans