How do I input data with forms based from one table to another tab

[Guest]

I am entering data in one table in the datasheet view. Here is my process.

I have one main roster table that has EmpNumber, Emp.Name, etc in one table
and another table with same info from main roster with radcon qualification
datefield.

Can I use an input form to pull from the main roster to link the empnumber
to name and then only have to input the radcon qual expire date field
manually? Can anyone help?

 

[Guest]

Hi Judy,

To do this right, you first need to link these two tables together in the
Relationship window. Empnumber needs to be the primary key in the main
roster table and something like empnumber the foriegn key field in the other
table. After creating this relationship, enforce referiential integrity. If
this doesn't work, you may have bad data that needs cleaning up first.

Next create a form based on the roster table. On this form create a subform
based on the other table. With the relationship previously defined, Access
will automatically link these tables when creating new records using the form.