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.