Importing data into child table and linking it to parent table

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
My system has about 100 parts identified by a Part Number in the parent "configuration Table".
Each part has 5 to 10 documents that I would like to archive. 
I created a child table named 'documentation' which gather records called 'documents'.
I created a lookup field to the parent "configuration table" which is the field "Part Number".

Because I have so many references to create, it seems easier for me to list all the documents under excels and to import it them all at once.

The file I upload has the following fields:
Part Number (My lookup field) / Document Number / Document Type / Link to the document...

My problem is, when I upload, all the documents end up linked to the same part (The one listed first...).


That seems like a pretty straightforward issue but I can t find a way around..
Can anyone help?

thanks
Photo of Marlene

Marlene

  • 112 Points 100 badge 2x thumb
  • frustrated

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Is "Part Number" the key field on the parent table?  If its not the Key field you will need to know the record ID, so you can import the [Related Part].

 You cannot import into lookup fields.
Photo of Marlene

Marlene

  • 112 Points 100 badge 2x thumb
Thank you. Unfortunately , although Part Number is the key field to me, I was not familiar with the concept and the current Key field in quickbase seems to be a record number link to the order in which I filled the master table.
Can I change the Key filed now? I have 5 other child/parents relationships that work fine and I do not want to mess everything up... 
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
If you don't want to cause any other issues, I'd recommend doing a vlookup in excel to match the part number to the QB record ID#.

You will need to export a report with two columns ( Part # & Record ID#),  then do the vlookup on your import data, to get the [Related Part] value.

There are a lot of tutorials out there for vlookup help.  But let me know if you get stuck on the QB side.