I have made a customer quote file with two tables. One for inventory items and another for customers. A form for inputting data that is as below.
Customer ID (from customer list) type in data
Customer Name (from customer list) auto fills when typing in customer ID
Part Number (from inventory item list) type in data
Description (from inventory item list) auto fills when typing in part number
OEM (from inventory item list) auto fills when typing in part number
Price type in data
I would like to input the Customer ID from a drop down list and have it auto fill Customer Name. In the drop down list, I want to see both the Customer ID and Customer name.
I am a somewhat novice with Access and am lost as to how to do this. Any help will be appreciated.
Thanks
darrellx