I am new to access and self teaching.
Trying to create a form on which I want to add a field for "Employee". I have a separate table called "Employees". When I use the combo tool (Table design view) and select "I want the combo box to get the values from another table or query", I then select the Employees table and it only shows ID and LOCATION as selectable fields.
On the table, I actually have:
ID
Employee Last Name
Employee First Name
Location
Why cant I see Employee First and Last name as selectable field?
Thanks for the education!