Forum Discussion

DanaDana's avatar
DanaDana
Qrew Cadet
9 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
9 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.
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
9 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.