AnsweredAssumed Answered

Auto population of Join Table

Question asked by IanAllan(newuser) on Apr 17, 2013
Latest reply on Apr 19, 2013 by philmodjunk

Title

Auto population of Join Table

Post

     FM help says " Each record in the “join table” would have the foreign key fields of the two tables it is joining together.  Nothing special needs to be done with the foreign key fields in the join table as they will get populated with data from the other two tables as records are created.  It is not uncommon for a join table to have a lot of records in it – since records are created in the join table as records are created in the two tables it joins."

     My join table is not automatically populated. If I manually enter the keys all works. But the creation of a record in the related tables on either side has no effect. Both related tables are enabled to write to the join table.

     I am looking for details of what FM needs to "create records in the join table as records are created in the two tables it joins"

     My situation involves Work Orders and Employee Time Records. Many Employees work on Many Work Orders on any date.

     Thanks

     Ian

      

      

      

      

      

      

      

FMP_Structure.png

Outcomes