Lookup field not populating from parent table

Question

I have a lookup field from a parent table, where the field auto-populates based on selection in the reference field. However today it stopped working properly. The values are all still in each record, but if I add a new record, the lookup field no longer auto-populates. Also, if I take an existing record and change the reference field value, the lookup field populates with "???", although if I put the reference field value back, the lookup field re-populates with correct value.

I've made no changes to the lookup field or the relationship. I have made other unrelated changes to the child table (which is a join table in a many-to-many relationship). I tried removing the lookup field and adding it back, but it did not fix it. Can anyone help? Thank you!

Parent table = Controls
Parent table reference field = Control ID
Parent table lookup field = Control Description (NOT WORKING)
Child table = Evidences Mapped to Controls

Adding new record:

Existing record:

------------------------------
Diane Sinawi
------------------------------

markshnier__you · Answer

On the top screen shot you should edit the field properties for the Related Control to set the Proxy field to be the Control Description and Controls Description field is the one that should be on the form.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

dianesinawi1 · Answer

I don't want the Description as a proxy field - Description should auto-populate when the Control ID number is selected.​------------------------------Diane Sinawi------------------------------

markshnier__you · Answer

Maybe try my suggestion and see how it behaves. Remove Related Control from the form.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

dianesinawi1 · Answer

I tried it before I replied previously. It just makes the Description populate with control Number choices, instead of the actual control number field.I need to be able to select the Control Number from a list of numbers, and have the Description auto-populate with the descriptionYour suggestion:How it should be:I tried using the Related Control and also the proxy Record ID for the reference field - both gave me a dropdown with the Control Number options, but neither populated the Description------------------------------Diane Sinawi------------------------------

dianesinawi1 · Answer

I ended up recreating the join table, setting up relationships with the Control and Evidences tables, and now its working. I still don't know why it broke in the old join table, because I setup the relationships, lookup fields, etc, exactly the same as the old one, but at least its working now.------------------------------Diane Sinawi------------------------------

Forum Discussion

Lookup field not populating from parent table