Skip to main content
Question

How to get a Lookup Field to Auto-populate when you import into the Related Field

  • May 5, 2017
  • 0 replies
  • 100 views
I have a very large table where I am constantly importing new data. I have a relationship setup where I import into the "Related Parent" field. I have a lookup field setup but it's not populating with data when I do an import. It'll pull the lookup field data when I manually select the "Related Parent" record. I have 3,481 entries where I need to fix this error. Any idea how? 

Thanks in advance! 
      This topic has been closed for replies.

      • ChrisChris
      • Registered
      • May 5, 2017
      Hi Dana,
      You indicate that you're importing new data, and are also importing into "Related Parent". Since it's lookup fields that are not populating, perhaps those parent records do not exist yet(?) See if the Related Parent ID # is the Record ID# in the parent table.
      • anomDiebolt
      • Registered
      • May 5, 2017
      I am not certain (1) how you are importing your data or (2) where a lookup field "is not populating" but what you might do is run a query after the import to display those records where [Date Modified] is equal to today (include the lookup and related parent fields in the query). Then check if this cures the problem and let us know.
      • DanaDana
      • Author
      • Registered
      • May 5, 2017
      I realized what I did wrong. I have 3 parent-children relationships setup like this in one form so I have all 3 lookups rolling up into one field by using the dynamic form rules. It was a limitation of that rule that was causing the error. I got rid of that and used a formula instead. All of my lookups are pulling properly. I apologize for the confusion! 
      Terms & ConditionsAccessibility statement