Linking information

[Terry]

I want to be able to create a form that adds information
to a table (name table). One of the fields in the form I
want to be a drop down box whose information is populated
from another table (employee table)(other than the one i
am adding info to). The user can simply scroll down the
list and select a name (populated from employee table)and
it will populate in the corresponding field in the name
table. Is this possible? thanks for your help.

thanks a million

 

[Damon Heron]

Its not clear from your question why you would have an employee table
(presumably with emplID, empName, Address, etc.) then a name table
(incidently, name is not a good name as it is a reserved word). If you are
selecting employees to assign tasks, then....? Think about your table
design. Then clarify your question,

Damon