Lookup field not populating from parent table
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,...
Forum Discussion
I don't want the Description as a proxy field - Description should auto-populate when the Control ID number is selected.
------------------------------
Diane Sinawi
------------------------------
------------------------------
Diane Sinawi
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendMaybe try my suggestion and see how it behaves. Remove Related Control from the form.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- 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 description
Your 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
------------------------------ - 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
------------------------------