A join query

Hi everybody,
I need i query that i will run behind VB, this query will take a value from a text box, and look it in the ACCESS DB provided, This is am easy part, the difficult part for me is when i need to join 2 or mor tables, e.g.
Take from the textbox some characters say "JACK", take from a Combo the value "FULLTIME" (found among other values like HOME, PART TIME.....), and go to the tables FACULTY(for the part of the name given) and to the table ASSIGNMENTS(for the assignment chosen) and find me everyone who has "JACK" anywhere in his name from FACULTY and who happens to be in the ASSIGNMENTS table a "FULLTIME";

This query should bring me everythinge Like : JACK XX, JACKOB, JACKOBS, JACKSON,... and who have the value Initiated in the Combo, this can be done because of the _PK and _FK of the DB. These 2 tables communicate through the relations between their keys. Can anyone help me with that please? Received on Thu Dec 18 2008 - 15:24:54 CST