AnsweredAssumed Answered

Set & use variables in different tables, different files

Question asked by hungbui on Sep 24, 2018
Latest reply on Sep 26, 2018 by jbrown

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.


Thank you.