filter 1 table based on values in another table

[markjkubicki]

this may be a <stupid> way of doing this but... I'm totally lost, so here goes:



I have 2 tables that (could / should ?) be related in a 1-to-many...
table_1 has a field: fixture_type, its values are unique
table_2 has fields : fixture_type and sub_title; many records in table_2 could have the same value for fixture_type, but any value for fixture_type in table_2 will always be found in table_1...

I also have a report with table_1 as its record source
I want to filter it for records where an equal value for fixture_type exists in both tables, and the record in table_2 with the equal value also has a value in the field sub_title that equals some_value


don't have a clue where to start...

thnx in advance,
mark

[jas0501]

Here is the sql code

SELECT Table2.FieldType, Table2.SubTitle
FROM Table1 INNER JOIN Table2 ON Table1.[Field Type] = Table2.FieldType
WHERE (((Table2.SubTitle)="Whatever"));