Filtering on many-to-many relationships

[ezylstra]

I have database that associates companies with service regions (many-to-many relationship #1) and also with services (many-to-many relationship #2). I've successfully made drop-down lists to associate a company with their service region and services.

Now I've hit a wall. I want to filter on those two relationships, i.e., get the list of companies in a selected region offering selected services (1 or more).

I know it can be done, but have hit serious brain fatigue.

Suggestions/examples?

Thanks,

E

[Villeroy]

Search this forum for "Power Filtering"

Edit: Added 2 more pairs of queries and forms. One of them does not use any "power filtering" at all.

[ezylstra]

Many thanks. I'll give this a good look.

EZ

[ezylstra]

Villeroy,

What is the field in the forms that you entered your notes? It is ever present, but I can't figure out how to work with it other than edit the text contents.

OpenOffice is a great tool to make me feel pretty stupid.

Thanks for your help, again,

EZ

[Villeroy]

The yellow rectangles on top? They have nothing to do with the database. These are text boxes from Writer's drawing toolbar. The companies form has an ordinary text paragraph on top.
I have no idea how to (re-)move them. While in edit mode, they should be selectable like any other shape. Strange.

Edit: This time I used normal text paragraphs with yellow background color

[ezylstra]

Thanks. You've been a huge help.

EZ