Listing multiple values in a Drop-down list - HOW?

[Lightbulb]

I want to list multiple values per line in a drop down list in Ultradev. For example, I have an inventory database that has the users id number in the inventory table which is linked to a table called users by the users id number. The users table also has the users first and last name. The field I want to search on is the users id number. However, I want the user to know what user the id number corresponds to without the user having to have a printout of users and their id numbers. I want each line in the drop down list to have the users id number, first name, and last name that corresponds to the id number. Is it possible to do this in Ultradev? If so, how? So far, I have only been able to produce a drop-down list that produces one field value per line. By the way, I am using an MS Access database. Please help.

 

[Cheech]

I was able to add multiple values only by handcoding the extravalues in to the code. UD may do it for you but that worked as a quick solution for me. Live long and make your kids suffer..

 

[chandler]

Populate the drop down list with query results using CFOUT tags in your form. I'm not sure if Ultradev has something to do this easily. I use DW 4.0 instead of Ultradev and did something similar. I did the page/form layout in Dreamweaver and then did the coding in CF Studio. Chandler
I ran over my dogma with karma!