Linking Forms

[Neil Greenough]

I have a form for each employee. This form contains their contact details.
Now what I want is for me to be able to add performance indicators for each
individual for each month of the year. There will be 10 different
performance indicators for each individual.

Now I have a table for contacts, with employeeID as my primary key. I also
have a table listing the months and a table listing the years. Now, how
should I create my performance indicators table/form? Do I need to include
EmployeeID as my primary key so I can link the two forms? I have spent about
an hour playing about with this and had no joy.

Thanks in advance

 

[James Goodman]

How about:
Create a PerformanceIndicator type table, containing an integer ID field &
other information about the performance indicator.

Then create a PerformanceIndicator_Contacts table, which joins the two
together. This should contain the EmployeeID, PerformanceID, AssessmentDate
& PerformanceScore fields...