Return to FileMaker.com
importing information from one table to another using a script
I want to write a script that will copy certain pieces of information from fields in one table to fields in anther table. how do I do this?
You can copy data over by storing the data temporarily into variables and then go the to the layout and record (or new record) that you want to set the data for.
However, usually duplicating data is not a good practice unless needed for a specific purpose.
Set Variable [ $field1; TableA::field1 ]
Go to Layout [ TableB ]
Set Field [ TableB::field1; $field1 ]
Retrieving data ...