Matching one Table to another.

[airbus2]

I have a simple question to a complex structure. What is the best way to setup this example? I have 10 employees identified by their employee number in one table called "employees". In another table I have 15 courses that they have to take (test 1, test 2, test 3, etc.). I want a form (frmTests)that will show their score for each test.

 

[PWise]

well you will need another table with these fields

EmployeeScoreId
EmployeeID
TestId
Score

 

[lespaul]

Do you really have your second table set up like Test1, test2, test3,etc? that's not normalized...something like this would be set up like this:

Employee
EmployeeID
EmployeeName

Test
TestID
TestName

EmployeeTests
EmployeeID
TestID
Score

Leslie

 

[lespaul]

you may also want to add a TestingDate field to EmployeeTests so you know what day the person took the test (if that's applicable)

Leslie