AnsweredAssumed Answered

Automatically creating records and filling some fields

Question asked by WilliamdelaMaza on Apr 1, 2011
Latest reply on Apr 1, 2011 by philmodjunk

Title

Automatically creating records and filling some fields

Post

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?

Outcomes