If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking Forms
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 |
#2
|
|||
|
|||
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... -- Cheers, James Goodman "Neil Greenough" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
linking forms (without using sub forms) & writing a macro | Adena | Using Forms | 1 | September 27th, 2004 01:24 AM |
linking 3 forms to move to the same record | levi | Using Forms | 4 | August 11th, 2004 11:48 PM |
Linking Forms to Help Files | Colin Halliday | Using Forms | 0 | June 18th, 2004 05:47 AM |