Field Data

Hi Paul

Yes you can.

First set up your second table with the name ID and name field together with other fields eg department, startdate, etc.

Then create a query and link the two tables on the Name ID field.

Add all the fileds to the query grid from the second table apart from Name. Add the Name field from the first table (containing just Name ID and Name).

Then when you view the query try adding a new record.
The Name field is populated automatically after choosing a name ID.

The same result can be achieved with form instead of a query but you will need to link the tables with Database Tools, Relationships. Then using the Form Wizard choose all the fields from the second trable and the Name field from your first table.

Heres's an example if you need it.

Hope that helps and can be applied.

Regards
Doug Dunn
Best STL