4 Replies Latest reply on Oct 8, 2014 11:28 AM by philmodjunk

    creating records in a different table based on a Single record

    DavidHowe

      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.