Need help in returning values from tables

[trent]

I have two tables that will contain the information that I need the third table that will be used for constant data entry to auto fill in two of the fields (Class, Rate)based on four criteria from the first two.

Table 1
EmpID Name
1 EMP1
2 EMP2
Table 2 (A Subtable of Table1 based on EmpID)
EmpID ACDate Class Rate MJob SJob
1 1/6/13 A 15 100 1A
1 2/6/13 B 20 100 1A
2 1/6/13 A 18 100 1B
Table 3
Name WDate MJob SJob Class Rate
EMP1 1/7/13 100 1A A 15
EMP1 2/5/13 100 1A A 15
EMP1 2/6/13 100 1A B 20
EMP2 1/6/13 100 1B A 18

 

[rzw0wr]

You may want to read the following,

http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html

Dale

 

[trent]

Thanks for your responce. I can normalize the text items but cannot do the normalization to the dates in table three because they will be equial to or less than the dates in table two to return the correct answer.