Dave
You posted in a "tables" newsgroup, so your question must relate to how to
do this in a table...
First, you don't want to! As a relational database, Access doesn't need to
store a person's name more than once.
Second (a "tables" newsgroup, remember), you DON'T want to be doing data
entry directly in a table. Access tables store data, Access forms display
it and get used for data entry & validation.
Third, if you are forcing someone (even yourself) to remember EmployeeID,
I'd like to introduce you to the combo box in Access forms. You can create
a combo box based on an Employee table, displaying not the EmployeeID (who
cares about the specific ID, it's the person that's important, right?!) but
the person's information, then select the correct person.
