Using Second Field in Value list

[emjay]

Greetings,

I have a table which has the two fields, Listname and ListID. The ListID is unique per record and auto-entered, the Listname is simple the name. For example a record would have a ListID of "1001" and it's associated Listname would be "Heiroglyphics Today"

I created a value list with a pull down menu to populate a global field. Since "1001" doesn't tell the user anything helpful I need them to see the actual Listname. But, I need to store the ListID to assure the correct record will be used later on in scripts, etc.

I can make the Listname show in the value list but once selected all I see is the ListID. I'd like to store the ListID, see the Listname.

How does one do this?

Thanks.

[AudioFreak]

Why not just make the Listname field a lookup based on the Listid?

[John Mark Osborne]

You could also try using a popup menu instead of a drop-down list. Popup menus will display the second field even though the first field is being stored. This popup menu feature requires FileMaker 8 or later.

[emjay]

Thanks for the ideas but unless I don't understand your suggestions they don't solve my issue.

The problem I'm having is want the second field to continue to show in the layout but I need the first value to work in the script in the background.

Perhaps this is a more clear explanation

[The Shadow]

Here's an example of some of the simple interface choices you have for displaying the choice using a valuelist.

Lists.fp7.zip

[Robert Kidd]

And...

Lists.zip

[emjay]

Thanks a lot. This was very helpful.

Cheers,

MJ