Page 1 of 1
Filtering on many-to-many relationships
Posted: Fri Jul 14, 2017 12:29 am
by 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
Re: Filtering on many-to-many relationships
Posted: Fri Jul 14, 2017 8:03 pm
by 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. |
Re: Filtering on many-to-many relationships
Posted: Sat Jul 15, 2017 7:42 pm
by ezylstra
Many thanks. I'll give this a good look.
EZ
Re: Filtering on many-to-many relationships
Posted: Sun Jul 23, 2017 9:25 pm
by 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
Re: Filtering on many-to-many relationships
Posted: Sun Jul 23, 2017 10:08 pm
by 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 |
Solved, Re: Filtering on many-to-many relationships
Posted: Sun Jul 23, 2017 10:39 pm
by ezylstra
Thanks. You've been a huge help.
EZ