I am new to Access and having a hopefully simple problem, I want to have the first and last name appear in a table as text. Here is what I have set up.
Form with combo box which pulls name from a query which ties first and last name together
Query is created from table which displays customer contacts, CustomerID is autonumber and primary key
The table the above form reports to pulls the CustomerID number instead of the text I want displayed.
How can I have this table display first and last name from a table vs the coresponding primary key number?
Thanks,
Kevin