Filter Form on Multiple Criteria (relational design)

[FormforSearching]

I have a relational database that contains a catalogue of resources, which
are categorized by audience, topic and type. Each resource can be
appropriate for multiple audiences, and fall into multiple topics or types.

The database contains 7 tables:

Main Table:
-Resource (the catalogue with resource title, date, number in stock,
language…)

List Tables:
-Audience (lists the potential audiences with their corresponding IDs)
-Topic (lists the potential topics with their corresponding IDs)
-Type (lists the potential types with their corresponding IDs)

Relationship Tables:
-ResourceAudience (lists which audiences apply to specific resources)
-ResourceTopic (lists which topics apply to specific resources)
-ResourceType (lists which types apply to specific resources)

Is it possible to search the catalogue and return results only matching the
criteria entered by the user? I have managed to sort the records based on 1
criterion using an inner join, but now I want to know if I can do this with
multiple criteria.

Any help is greatly appreciated.
Thanks,
Julie

 

[Golfinray]

Go to www.allenbrowne.com or check Martin Green at www.fontstuff.com. Both
have detailed descriptions of what you are trying to do and the way to do it.