Table Relationship needed?

[Neil Greenough]

I have a form containing employee information; "employeeID", "department"
and "city". In this form, I also have a subform which contains performance
information for that employee for specific dates. Currently I had a link
between the "performanceID" and the "employeeID" so that the tables match
the relevant employees.

Now, in my subform, I have also included "city" and and "department." When I
fill in the performance subform for the individual, I would like the subform
to automatically fill-in the "department" and the "city" for that specific
individual by looking at the info in the main form (contact details.)

How do I go about this? Do I need to add a relationship? I have tried doing
this from the main relationship screen, however it won't let me add another
one, but only edit the "EmployeeID" and "PerformanceID" one.

The reason I want to do this is, I would like eventually to be able to
calculate what an employee achieved on a certain date. I would also like to
see what a department achieved by adding together all the details for those
who fall in a certain department. Again, I would like to do the same for the
city.

Many thanks

 

[MacDermott]

Unless your employees tend to move from department to department, and city
to city, you don't need to duplicate the information in the main form.
When you want to do your sums, simply use a query which links your
Performance and Employee tables.

HTH
- Turtle