Need help w/ query - indirect match across two tables.

[lockon]

I am drawing a complete blank on how to query the following:

 

table a:

type_id, generic_type, specific_type  (specific types are unique, but generic type can be repeated for several specific_types)

 

table b:

obj_id, type_id

 

I would like the user to be able to select the 'a.generic_type' from a list (a combobox), but in the query return a list of obj_ids from table 'b' where *all* specific_types for the passed in generic_type are matched.

 

Do I make any sense?  

 

Can anyone help me with the query?

TIA!

Sunil

 

[fenway]

I don't understand... give some sample data.