add parent record during import to child table

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a parent table called "Addresses" and a child table called "Work Orders"

Sometimes import multiple work order records and the Addresses record does not exist yet. Can i import into the "Work Orders" table and automatically create the "Address" record with data in multiple fields in the "Address" record?

Photo of M

M

  • 60 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
Not likely.  The only mechanism I know to create a Parent with Children at the same time is the Grid Edit functionality where you can enter children on a Parent Record's Add Parent form.  ie enter the Address reord and the Work Orders on the same form.  So using Copy and paste of the Work Order data may be possible into the Grid Edit children records and manually enter the Address header info on the Parent Address Form at the same time.