drop down list box

[beti]

I have a question regarding the drop down text box.
I have a drop down text box where list out all the company name.
when user select the an entry from the drop down list box, the a datawindow will display regarding information.
Here is the problem. I will need to retrieve the company name from a company table, however, the company name may be duplicated. Therefore, I need to use the company ID instead of company name to pass to the datawindow below. How can I do that (butI need to display the company name to the user not companyID)? I know how to pass the display value (company name) to the datawindow...but how can I pass the hidden value company ID?

 

[BetterLateThanNever]

Hi,

Use a dropdown datawindow instead of your dropdown listbox. Make the datawindow up of company name and company id. Use the name as the display value and the id as the data value. You can then use the dropdown datawindow as the master and from it supply the detail datawindow with the required company id.

Cheers.