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
Im pretty stuck here so if anyone here can help ill be really gratefull
Thanks for your help
Jonathan Hook
