Duplicate records via subform in Access 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form New Hires (based on table New Hires) with a subform Dependents
(based on table Dependents). Table New Hires has been populated with new
employee information (name, address, SSN, etc ...). Table Dependents is empty
and awaiting entry through subform Dependents.

There is also a query New Hires that joins data from tables New Hires and
Dependents.

When I add three dependents to the first employee record through the subform
Dependents, these three dependents are duplicated to each employee listed in
query New Hires. As I scroll through the form New Hires, I see these three
dependents listed on the subform Dependents for each employee.

I have reviewed the relationship between the two tables, and I have reviewed
the form controls. I am obviously overlooking something.

Any ideas?

Rachael
 
I have reviewed the relationship between the two tables, and I have
reviewed the form controls.
The table New Hire needs to have a primary key (autonumber) name EmpID in a
one-to-many relationship to the table Dependents that has number (integer)
field as foreign key.
The form/subform needs to use the EmpID for the Master/Child links.
 
Back
Top