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