Forum Discussion

LB's avatar
LB
Qrew Trainee
7 months ago

Help with record pick field

Hello, 

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. 

Thanks!



------------------------------
LB
------------------------------

2 Replies

  • 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'? 

    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. 

    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. 



    ------------------------------
    Chayce Duncan
    ------------------------------
    • LB's avatar
      LB
      Qrew Trainee

      That worked, thank you!!



      ------------------------------
      LB
      ------------------------------