TABLE1: CODE WORK
1 JACK OR JILL
2 JACK OR JILL
3 JACK OR JILL

TABLE2: CODE WORK
4 SUZY OR MARY
5 SUZY OR MARY
6 SUZY OR MARY

now in my FORM1, the user needs to enter a CODE. I need the CODE to lookup the values from TABLE1 and TABLE2. If the user has entered a CODE value from TABLE1, the WORK will then lookup values from another table that would be either JACK or JILL. If the user has enetered a CODE value from TABLE2, the WORK will then lookup values from another table that would be either SUZY or MARY.

HOW DO YOU DO THIS???? PLEASE help me!!! :-(