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

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

Outcomes