1. Sales table

   1. Each record contains the following information for the sale:
      1. Serial number
      2. Date of sale
      3. Line Items
         

2. Line Items table

   1. Each record contains the following information for the line item:
      1. A link to its parent Sale record
      2. A link to the Product record that is being sold
      3. The quantity of the product that is being sold
      4. Links to the relevant Pick List records
         

3. Products table

   1. Each record contains the composition details of the product:
      1. Links to the parts that it is composed of
      2. Links to the relevant Line Item records
         

4. Parts table

   1. Each record contains the following information for the part:
      1. A link to its parent Product record
      2. The required quantity for this part
         

5. Pick List table

   1. Displays all of the parts that need to be picked, as well as how many of each part to pick
      

The client was using a "Find Record" action in an automation to identify the specific product components they needed to pack.

This worked fine and they were able to successfully find the product component records they needed.

After that, they needed each of these records to be created as a new record in a table that was formatted specifically for packing.

We utilized a script that would take in the results of the "Find Record" action, and for each of them, create a new record in the appropriate table with the data the client needed.