Skip to main content

Linked field in a form: display as different column?

  • April 8, 2020
  • 1 reply
  • 0 views
N

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?

    1 reply

    N
    • Noah_Glaser
    • Author
    • New Participant
    • 3 replies
    • April 9, 2020

    Here’s some further information:

    Here’s what the form looks like now:

    When I expand “Campus Building”, here’s what I get:

    I don’t want to display “BSB” here, but rather the associated building’s name “Behavioral Sciences Building”; likewise, I don’t want “AOB” but rather “Administrative Office Building”.

    Here’s a snippet of the table that building data are coming from (where BANNER Building Code is the primary key):

    Reply


    Most helpful members this week

    Terms & Conditions