Hello FM Community,
Hope everyone are doing well.
I have this issue and have been read all day on the forum but can find a suitable solution.
My current FM solution utilised many tables in multiple files. I used to use set variable and set field in my script to carry info from one table to the next, but all in the same file. Now I want to do the same thing but in different related files.
One example is creating a purchase order which in parent file (purchase order master) and line items in children file (purchase transaction and stock transaction).
Once I created a PO with all master data such as PO number, Supplier, Project ID & Delivery Date ..etc.
I want to capture these data (by set global variables) and use them (set fields) when I get to other files (PO transactions and Stock transaction).
Any suggestion is very much appreciated. I am currently using multiple scripts to copy and paste these data across. My next move is to export one single record from PO Master, then import to children files.