Drop down lookup problem

Giganews Newsgroups
Subject: Drop down lookup problem
Posted by:  John (John@nospam.infovis.co.uk)
Date: Wed, 30 Aug 2006


I have a client table with clients and their ids. Some client names are
duplicate as they have several locations but ids are unique, so for example;

ID    Company
23  MyCompany Inc
27  MyCompany Inc
56  MyCompany Inc

On the orders form I have the clients drop which displays all the clients
for user to select. The problem is; as company names are duplicate selecting
by company name is not enough. How can I select a company but also get the
client id behind the scene? Ideally I do not want to store the id in the
client field bound to the drop down as the rest of the app expects client
name in that field and not client id.