No need to populate all those fields in a second table. Just enter EmployeeID
using a combo sourced from Employee table and join the Employee table in your
query that feeds the form.
--
Build a little, test a little.


"Terri" wrote:

OK here goes, hope this is clear

I am wanting to set up a database where info is selected in one field and
then multiple fields are populated. EG entering username from drop down list
automatically fills in Name, Dept and Ext so save looking all those up each
time.

In excel I would use the lookup function and put formulae in each cell.
Is this possible in access? Any help greatly appreciated.
--
Thanks
Terri