AnsweredAssumed Answered

How to automatically create related records in a third table

Question asked by RobertChan on Jul 11, 2014
Latest reply on Jul 14, 2014 by RobertChan

Title

How to automatically create related records in a third table

Post

     I am new in Filemaker.  I have an order header related to order details by the order number.  I also have a packing details table related to the order header via the order number.   I have another Kit master related to the Kit details via the parent item code. I have the order details showing as a portal in an order entry layout.  User will enter the kit item code during order entry.  How can I get Filemaker to expand the kit to the component level based on the kit details and fill out the packing table with the expanded components?

     e.g.

     Parent 1 - Component 1 x1 , Component 2 x 1, Component 3 x 2.

     Parent 2 - Component 4X2, Component 5x 1, Component 6 x 1.

     When user order 10 of Parent 1 and 5 of Parent 2, I would like the packing details table to have the following 6 records.

     Component 1 with 10 units,

     Compoennt 2 with 10 units

     Component 3 with 20 units

     Component 4 with 10 units

     Component 5 with 5 units and

     Component 6 with 5 units.

     Thanks..

      

Outcomes