Forum Discussion

DanaDana's avatar
DanaDana
Qrew Cadet
8 years ago

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

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...
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
8 years ago
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.
  • DanaDana's avatar
    DanaDana
    Qrew Cadet
    8 years ago
    They do exist, the links work and are tied back to the parent perfectly. If I edit the child record by manually selecting the parent, it will populate the lookup field. 
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    8 years ago
    If you have the Related Parent ID# and its proxy field both on your child form, that may be the culprit. Try having only one or the other but not both on the child form.