link 2 fields on a master subform

[ISmith]

Hi,

I have two comboboxes on a master form. I need to link them together so
that combobox a's on change will update combobox b with maching records and
visa versa.

Then when a button is pressed the subform is populated based on the
selection in the two comboboxes.

EG, say I have 3 joined tables, table People has lookup fields to the two
other tables (Jobs & Skills).

On the masterform I want to be able to pick Jobs (combo A) and populate
combo B with Skills, or pick a Skill (combo B) and populate Jobs combo A,
then hit a button and populate the subform with people who are listed as
having Job selected in combo A and Skill as in combo B.

How would I go about this ?

I am using Access 2002.

Thanks

Ian