Script Trigger to create multiple records from one record in different tables
Hi I'm trying to automate the creation of some records in a table from the fields of one record in another table.
Using FileMakerPro 11 Advanced on a Mac
In Table "Orders" I have imported many files into a container field (1 for each record). Each record will then have a barcode scanned into a Customer ID# field so each file will match back to a related table with the customers ID#. I then populate an order field. The order field then populates various calculated fields based on the order type. Each record/order can represent multiple pieces of work for completion that I need to have as individual line items that match the order# in another table.
Table "Orders" Record 1
Container Field: xyz
File Path: user/xyz/filename
There are many other options with calculated fields as well.
Table 2 - Requires each True calculated field above to be a separate record in another table but with the same ID#
And so on and so forth. The actual number of potential fields is quite large (40+).
I would like to trigger the creation of the records in Table 2 when I hit a submit button in a layout based on the "Orders" Table.
Any ideas would be helpful. I'm new to scripts and have not found anything on the forum that seems to be similar to what I'm trying to do.
Look forward to your comments.