I need help displaying multiple columns in a combo box

[Megos]

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!

[June7]

This is setting Lookup in table. I never set Lookups in tables. Users don't work directly with tables and queries. I create forms and reports for user interface. Build combobox on form.

Combobox (or table Lookup) RowSource like:

SELECT [Customer ID], [Name] FROM Customers ORDER BY [Name];

Set ColumnWidths: 0";2"

Name is a reserved word. Should not use reserved words as names. Also, avoid spaces and special characters (underscore is exception).