Filtering on many-to-many relationships

Discuss the database features

Filtering on many-to-many relationships

Postby ezylstra » Fri Jul 14, 2017 12:29 am

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
OpenOffice 4.1.3
ezylstra
 
Posts: 5
Joined: Fri Jul 14, 2017 12:18 am

Re: Filtering on many-to-many relationships

Postby Villeroy » Fri Jul 14, 2017 8:03 pm

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. 
Attachments
topic89512.odb
(40.35 KiB) Downloaded 73 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25954
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Filtering on many-to-many relationships

Postby ezylstra » Sat Jul 15, 2017 7:42 pm

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

EZ
OpenOffice 4.1.3
ezylstra
 
Posts: 5
Joined: Fri Jul 14, 2017 12:18 am

Re: Filtering on many-to-many relationships

Postby ezylstra » Sun Jul 23, 2017 9:25 pm

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
OpenOffice 4.1.3
ezylstra
 
Posts: 5
Joined: Fri Jul 14, 2017 12:18 am

Re: Filtering on many-to-many relationships

Postby Villeroy » Sun Jul 23, 2017 10:08 pm

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 
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25954
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Solved, Re: Filtering on many-to-many relationships

Postby ezylstra » Sun Jul 23, 2017 10:39 pm

Thanks. You've been a huge help.

EZ
OpenOffice 4.1.3
ezylstra
 
Posts: 5
Joined: Fri Jul 14, 2017 12:18 am


Return to Base

Who is online

Users browsing this forum: No registered users and 7 guests