I am trying to import a file into a child table in QuickBase. After importing the data, I am unable to see the relationship between the child record and the corresponding parent record in the parent table. ------------------------------manohar vankireddy------------------------------

The children will not magically match up with the correct parents on their own. You need to include the field for Related Country Pipeline in your import.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

But it is not showing while importing------------------------------manohar vankireddy------------------------------

I don't understand. What is not showing during importing? The field for Related Country Pipeline will show. The lookup fields cannot be populated via an import. They are lookup fields from the Parent Countries Pipeline table. ------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Hi Mark, The related field names "Country Pipeline - Study Number" and "Country Pipeline - Country" of the parent table "Country Pipeline" are not appearing while attempting to import data into the child table "Sites Pipeline". Please refer to the attached screenshot for clarification. Can you please provide guidance on how to correct this issue? ------------------------------manohar vankireddy------------------------------

The field for Related Country Pipeline will show. That is the field that you need to populate. The lookup fields cannot be populated via an import. They are lookup fields from the Parent Countries Pipeline table. Can you tell me more about the data in the Countries Pipeline table. What does each record represent. Is each record the name of a country?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

When importing a file into a child table in QuickBase, the parent lookup fields are not appearing in the import mapping options.

MarkShnier__You
Qrew Legend
2 years ago
The children will not magically match up with the correct parents on their own. You need to include the field for Related Country Pipeline in your import.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- manoharvankired
  Qrew Trainee
  2 years ago
  But it is not showing while importing
  
  ------------------------------
  manohar vankireddy
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    2 years ago
    I don't understand. What is not showing during importing? The field for Related Country Pipeline will show. The lookup fields cannot be populated via an import. They are lookup fields from the Parent Countries Pipeline table.
    
    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

When importing a file into a child table in QuickBase, the parent lookup fields are not appearing in the import mapping options.