Automatically creating records and filling some fields
I got a table (table1) from which I need to automatically create records in a separate but related table (table2) inside the same file. After these records get created, I need to auto-fill some fields with data from table1.
Table2 is going to be previously cleared-off all records before this record creation-procedure takes place, so there's nothing to mess-up there.
My questions are:
How can create empty records on table2 based on the existing records from table1?
How can I force FileMaker to fill some of the fields on table2 using data from table1?
I need to do this preferably with a single button. Can it be done?