AnsweredAssumed Answered

Value List - Need to show multiple fields for second value

Question asked by AdamHalstead on Jul 29, 2010
Latest reply on Sep 1, 2010 by AdamHalstead

Title

Value List - Need to show multiple fields for second value

Post

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.

Thanks,

Adam

Outcomes