Copy Parent and Child To a Different Table

[Josh_Klassen]

Hi,

I am trying to copy some information from a “parent table” and then add it to another “parent table” which I have been able to accomplish. However the problem that I am running into is it doesn’t bring over the “child” records.

In plain English. I am trying to create an invoice using information from the previously created work order. The work order has deference tables “time sheet” “Deficiencies & Repairs”. I would like to bring the “time sheet” records and “Deficiencies & Repairs” records over to the newly created invoice. Essentially creating a “copy” of the work order in its current state and allowing additional information to be added.

In this screenshot. It shows how the Time sheet is is referenced to the work order.

In this screenshot it shows the referenced tables i have created to house the new copies of the referenced tables.

How is this possible?

Thank you,
Josh

[Aleksi]

Hi Josh, please check this post…

Automatically create parent and child records one click Tips & Tricks 💡

I was running into a problem where I wanted my users to be able to add multiple days off for employees by just selecting a range of dates. This meant that I had to create multiple records from one form. I was able to accomplish this by using three tables. Table 1 (just updates) - is a single record form that gets updated, but no new records are added. Table 2 (just updates)- has a bunch of formulas in it that look back at table 1 to figure out how many records to create. My action button up…