Forum Discussion

MeaganMcOlin's avatar
MeaganMcOlin
Qrew Cadet
2 months ago

Reference Numbers Displaying Instead of Names in QuickBase

I have three tables in QuickBase: Physicians, UT Advanced Privileges, and Physician Privileges.

  • Physicians and UT Advanced Privileges are parent tables to the Physician Privileges table.
  • The issue: In the Physician Privileges table, the fields are displaying as reference numbers instead of showing the actual physician and privilege names.

How do I fix this to show the names instead? 

  • Look up the Physician Name from the parent Physicians down to Physician Privileges

    Go to the field for Related Physician and edit the field properties to use the Physician name as the Proxy.  Then change all reports and forms to use the Physician Name instead of Related Physician.

  • Look up the Physician Name from the parent Physicians down to Physician Privileges

    Go to the field for Related Physician and edit the field properties to use the Physician name as the Proxy.  Then change all reports and forms to use the Physician Name instead of Related Physician.

  • Hi Mark, 

    Will you talk me through this in a bit more detail? I am going to the Related Physician field in the Physician Privileges table and attempting to change the proxy field, however, there is nothing in the drop-down for the proxy field selection - so it seems I am misunderstanding something.

    Thank you!

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend

      Did you first do this :)

       

      "Look up the Physician Name from the parent Physicians down to Physician Privileges"

  • Got'ca! I was confused! That made all the difference. This worked. Thank you!