Using MSAccess 2007
Have two tables...
Table 1: information entered and only changes annually with effective dates
Table 2: data entered checks Table 1 (compares data in Table 2 with data in Table 1)
and if Table 2 matches or fails matching data in Table 1... display that information in Table 2 with a code, (A), (B, (C)
If so, can you explain how?