I’m creating a new member signup form for which one of the table entries is a linked record.
The data relationship is as follows:
New member has a linked field to Campus Building, which is a table with (among other things) Building Code (primary key) and Building Name (human-readable text).
What I want: for the Campus Building option in my form to display the building as Building Name
What currently happens: the Campus Building option in my form is the human-unreadable building code.
How do I get the form input to display the Building Name instead of the Building Code?