Multiple Table values visible in controll box

[Gary]

I have what hopefully will be a simple Tracking Log. But I am running into
issues. I have two tables one labeled employees which is a running list of
employees, and another a tracking log. The Employee table has the following
value fields (ID, First Name, Last Name Department, Title, Phone Number)
this is for a combo box with a drop down on a form labeled "Initiated By"
How can I show where the name appears as "Last Name, First Name" in the combo
box, and on the Tracking Log table? If you can’t already tell by my poor
choice of words, I am fairly new to Access.

 

[Jeff Boyce]

Gary

If you have name info in the Employee table, you don't need it (duplicated)
in the TrackingLog table. Instead, store the EmployeeID value in the
TrackingLog table to tell you which employee.

If you have a combobox (in a FORM, I hope!) that displays "LastName,
FirstName", one would hope that the bound column (usually the first field,
usually of width = 0) was the EmployeeID.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[ntc]

what Jeff is saying is that; the form is sourced on the tracking table

the tracking table must have an 'employee ID' field for cross referencing to
the employee table

when you put that combo box into the form - the wizard should prompt you as
to which table it (combobox) is to be based (employee table) but then will
prompt you as to where to store the value of the combo box (the bound value)
and you should identify the employeeID field of the tracking table for
that.....