School Project Drop Down Menu in from problems

Johnhook

New member
Local time
Today, 00:46
Joined
Sep 27, 2002
Messages
8
I am making a database for a warehouse for my school project. I have a form to enter item records. In this form there is a drop down menu to select the customer. I need a way of there being a drop down menu which incorportes the customerID and the customer name or a drop down menu of customerIDs that when selected shows the customers name or another way to solve the problem of more than one customer with the same name.

Im pretty stuck here so if anyone here can help ill be really gratefull

Thanks for your help

Jonathan Hook :)
 
Hi John

If you use the wizard to create the ComboBox, you can incorporate any fields you like for ID purposes.

You'll need option 3 "find a record based on.......etc etc" to get the form to open at the selected person.

Col
 

Users who are viewing this thread

Back
Top Bottom