Can't get next record button to move to next record

[rosscortb]

Hi,

I am trying to create a one(employee) to many ( assignment) database. Please see attachment.

In the form under Employee when I click next exmployee it goes to the next employee but shows the same assignment for the previous employee, how to do I get so they move together?

Thanks

Ross

[orange]

How are your tables (Employee and Assignment) related?

1 Employee has Many Assignments
so the Assignments table has a FK EmployeeId
and you have Form and subform linked on EmployeeId?