Hello-
I have two tables in a database, Customers (Customer ID, Name, Address, Phone, Email) and Account (Account Number, Balance, Account Type, Customer ID). I need to create a combo box in the Account table so that when Customer ID is selected it also shows their name. The combo box now only shows Customer ID and for the life of me I can't get it to also show their name. My row source is "Customers", bound column=1, column count=2.
I'm taking a Business Information Systems class with a horrible, unhelpful instructor and this class depends on my graduation in 6 weeks. I'm not very proficient in Access and if anyone can give me any insight as to what I'm doing wrong, that would be amazing.
Thanks!