Filter partner companies and their offerings

[lurisz]

Hey there,



I am creating a database in access where it should be possible to search partner comopanies and their offerings.
I want to be able to filter after every category (name, street, offering, job, type etc.) and also to combine multiple filters in the form for the end-user.

--> not every company has all offering and those who have education offerings dont always offer all types and jobs within.

How should I get this thing going?

Wishes
Lukas

[CarlettoFed]

Perhaps it would be easier and quicker to help you if you attached an example file.

[lurisz]

well, there's not too much made because I am stuck with my knowledge.
Here are the three tables I that are connected altogether( company with their offerings)

[Bob Fitz]

Can you post a copy of your db

[CarlettoFed]

Quello che chiedevo era un file accdb per poter sfruttare la struttura esistente, perchè quello che vuoi fare non si può spiegare con alcune righe ma è necessario creare un vero esempio che potrai poi vedere direttamente.
Ricordati di aggiungere anche la tabella quella delle Offerte, che appare come immagine nel primo post.

[Micron]

Quello che chiedevo era un file accdb per poter sfruttare la struttura esistente, perchè quello che vuoi fare non si può spiegare con alcune righe ma è necessario creare un vero esempio che potrai poi vedere direttamente.
Ricordati di aggiungere anche la tabella quella delle Offerte, che appare come immagine nel primo post.

Are you sure you posted that in the right thread?

[CarlettoFed]

What I was asking for was an accdb file to be able to take advantage of the existing structure, because what you want to do cannot be explained with a few lines but you need to create a real example that you can then see directly.
Remember to also add the table of Offers, which appears as an image in the first post.

[CarlettoFed]

Sorry for the mistake.
What I was asking for was an accdb file to be able to take advantage of the existing structure, because what you want to do cannot be explained with a few lines but you need to create a real example that you can then see directly.
Remember to also add the table of Offers, which appears as an image in the first post.

[Micron]

I couldn't see why you'd reply in Italian when the post shows it's German. At least that's what I figured the languages were, so I figured your browser tabs got mixed up.