AnsweredAssumed Answered


Question asked by on Jan 24, 2018
Latest reply on Jan 24, 2018 by

Hi everyone:


I'm trying to write a formula or script which will do the following:


  1. Takes the InvoiceNoID_FK field which resides in the TSheets table.
  2. Looks for same InvoiceNo field in the Jobs Table.
  3. Takes the ID associated with the InvoiceNo in the Jobs table and returns it back to the TSheets table as the JobsID_FK field which will then display the proper job header.


I'm currently doing this manually but I'm confident that there's a formula or script that can be written. I know it involves setting variables. The biggest problem I'm having is the syntax. I'd like for this to be trigged as soon as the InvoiceNoID_FK is modified.


Thank you very much: