Value List - Need to show multiple fields for second value
FM Pro V11
For a pop-up menu control I need to show in the menu from which the user selects, a string comprised of multiple fields, not just one field other than the first field.
More specifically, I am showing in the popup menu values from a table called 'Location'
Location contains a primary key 'idlocation', which I specify as the (first) value.
The other columns in location are a foreign key for another table 'buildings', and 'room number'.
I want the user to see in the menu: room number, building name, street address
e.g. RM 101, Orwell Towers, 1984 George Street
The building name and street address come from the building table.
I seem only able to select one field to show, which isn't enough to identify the location unless the user knows the ID number itself.