Skip to main content
Solved

Reference Numbers Displaying Instead of Names in QuickBase

  • December 11, 2024
  • 0 replies
  • 248 views

MeaganMcOlin
Forum|alt.badge.img+7

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? 

Best answer by MarkShnierYou

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.

MarkShnierYou
Forum|alt.badge.img+24

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.


MeaganMcOlin
Forum|alt.badge.img+7
  • Author
  • Registered
  • December 11, 2024

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!


MeaganMcOlin
Forum|alt.badge.img+7
  • Author
  • Registered
  • December 11, 2024

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