creating records in a different table based on a Single record
FileMaker currently imports data from a form. The table includes fields such as
Date1, date2, date3 …date7
Day1_job1, day1_job-2, day1_job3 … day7_job3.
Day1_job1_hours, day1_job-2_hours, day1_job3_hours … day7_job3_hours
I would like to create a related table that creates a record for each entry that is not empty. The results would look something like
Employee (john doe)
Any directions, ideas or hints would be greatly appreciated.