G
Guest
I have two tables, "Employee" and "department", which has a 1-to-many
relationship.
From "employee" I have the fields "employeeID", "Fname" and "Sname" and,
from "department", I have the fields "WeekID" and "rate".
When I go through the wizard I choose these fields. Unlike what I would
expect, I am not getting the step in the wizard which shows the fields from
"employee" in the main form and the fields from "department" in the subform.
Not only do does the wizard go straight to the step where I name the form
but when I create the form, each name appears as many times as there are
records. This hasn't happened before.
Just to note, in the query I have a criteria which states that I want the
three most recent records for each employee (using the date as identifier).
What could be wrong?
Cheers in advance
relationship.
From "employee" I have the fields "employeeID", "Fname" and "Sname" and,
from "department", I have the fields "WeekID" and "rate".
When I go through the wizard I choose these fields. Unlike what I would
expect, I am not getting the step in the wizard which shows the fields from
"employee" in the main form and the fields from "department" in the subform.
Not only do does the wizard go straight to the step where I name the form
but when I create the form, each name appears as many times as there are
records. This hasn't happened before.
Just to note, in the query I have a criteria which states that I want the
three most recent records for each employee (using the date as identifier).
What could be wrong?
Cheers in advance