relationship shows record id

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I created a relationship between two tables, but when I use display the related record, it only show the record ID, instead of the text field I want (called Description).

I know I fixed an issue like this before, but I can't find an option that fixes it.

Help?

Photo of EJ

EJ

  • 10 Points

Posted 5 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,558 Points 50k badge 2x thumb
The best way is to bring down a lookup field like [Description]. then edit the field properties of the [related record] to tell it that its Proxy field is [Description].

use the [Description] field on your form - not [related record]. That way it will behave properly for view and edit, automatically.
Photo of Adam

Adam

  • 20 Points
For me it worked if I selected the "Read only" option on the form editor field list. Granted, it's read only by the nature of it being a lookup field anyway, but ticking it caused the correct value to display. I know this answer is 2 years old, but I found it whilst looking for my own guidance and figured this might help others.