Help with record pick field

Question

Hello,&nbsp;
In my application I have a table that lists the diagnosis code and description that connects to another table to use the fields as options for a drop down. However, for some reason my fields have changed to what looks like should be a pre-populated field based on adding a record and I'm not sure how to change it back...?
In the screen shot the diagnosis field should look like the fields below select a code and the description will populate into the form based off of the selection.&nbsp;

Thanks!------------------------------LB------------------------------

chayceduncan · Answer

When you open the field settings of 'Diagnosis - DX Code', there should be a link to view the relationship that field is a part of. Can you open that and see if there is a field listed as a 'Reference Proxy'?&nbsp;

With relationships - there is the 'Related' field that directly links your two tables together, its the foreign key in your child table. You can also set another field as a 'Proxy' - where it will act as a dropdown for users on forms or grid edits. It sounds like you might have lost the proxy field that may have previously been the DX Code.&nbsp;

If you click into the 'Related' field in your relationship - there is a dropdown to set a proxy field, I would suggest picking from that dropdown the DX code value and that will convert it to a dropdown where your users will select the DX code which would then pull in the associated lookup description.&nbsp;------------------------------Chayce Duncan------------------------------

lb · Answer

That worked, thank you!!------------------------------LB------------------------------

Forum Discussion

Help with record pick field