CSV Upload... bulk record creation with related parents/children records...

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
  • (Edited)
I currently have a table titled Customers as a parent table and a child table titled Orders.
(a customer can have many orders)

I know I can upload a csv file that will create Customers records in bulk.

I was wondering if/how I could upload a csv file of Orders that associate with the appropriate existing Customers.
Photo of Dan Park

Dan Park

  • 440 Points 250 badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 69,774 Points 50k badge 2x thumb
When which is involved in a relationship, you will always have to populate the field such as [Related parent].
So it depends what the key field is of the parent record. Sometimes you may actually have a known customer number and you can choose to make the key field of your customer table that customer number. But another situations you might just have a Record ID being the Key field of the customer table.
If that is the case then in order to join up the orders you would need to populate that upload file with the record ID number of the customer somehow.  Sometimes the only way to do that is to download the customer table into Excel and then do a Vlookup on the customer name in order to get the Record ID number on the orders table and then you do your plate.