I'm trying to write a formula or script which will do the following:
- Takes the InvoiceNoID_FK field which resides in the TSheets table.
- Looks for same InvoiceNo field in the Jobs Table.
- 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: