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

Expand all | Collapse all

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

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

    Posted 04-07-2017 19:23
    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.


  • 2.  RE: CSV Upload... bulk record creation with related parents/children records...

    Posted 04-07-2017 19:46
    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.