Pop up Value list needs to show in concatenated field

[chiggins68]

• The table, "Address" has a field "Location".
• The Location field is formatted as a popup menu using a value list "Locations_VL" "Checked with "Override data formatting with value list"
• The value list "Locations_VL" is pulling from a table called "All_Locations" with a "Primary Key" field and a Location Field. the table is populated with separate locations
• The Value list "Locations_VL" is using the "Primary Key" as the first first field and the "Location" field for the second with the "Show values only from second field".

This works fine the issue is when I want to concatenate fields into a field "Main Address" I enter the Location field and I get the Primary Key instead of the Location from the Locations_VL table. I understand why its doing this but I'm not sure how to get it to show the Location field when in the "Main Address" field

Edited May 5, 2021 by chiggins68

[comment]

Do you have a relationship between Address and All_Locations, based on matching: 

Address::Location = All_Locations::Primary Key

If so, use the All_Locations::Location field for your concatenating calculation.