AnsweredAssumed Answered

creating records in a different table based on a Single record

Question asked by DavidHowe on Oct 8, 2014
Latest reply on Oct 8, 2014 by philmodjunk

Title

creating records in a different table based on a Single record

Post

FileMaker currently imports data from a form.  The table includes fields such as

Employee,

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)

Date (10/7/2014)

Job (A12-123)

Hours (8)

Any directions, ideas or hints would be greatly appreciated.

Outcomes