Grouping Fields

I have three fields that I want to group together. An Employee ID , Last
Name, First Name so that when I type in the ID field the corresponding name
fields will automatically fill in. Is this possible?

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.

--
Good luck

Jeff Boyce
Access MVP

"Dave" wrote in message
...
I have three fields that I want to group together. An Employee ID , Last
Name, First Name so that when I type in the ID field the corresponding
name
fields will automatically fill in. Is this possible?