Filter in a subforum

[Rolando]

Hello!
I need a help to crate a form with subform based on filter criteria.
I have tables:
Category
Post
Person
Order Detail
Order

In Category I have three fields yes/no (checkbox)
In Post I have ZIP and Post Name
In Person Name, Surname
…. (ofcourse with all ID's and Primary keys)

Now I would like to create a form with subform where I can select person name with dropdown menu. But records (names) in this Dropdown menu must be first filtered by Category criteria with checkboxes and rest of records must be filtered by Post criteria where I select Post Name from dropdown menu.
I don’t have any idea How to create this kind of form. I try everything but no success. Did somebody have any idea how to do this or some kind of solution withc will help me to solve this problem?
THX for any help

 

[CyberLynx]

This is a lot easier to demonstrate than it is to explain. You want cascading Combo Boxes (search the Forum for that) and then Filter the SubForm based upon what is selected within those Combo Boxes (again - search the Forum for Filter Search).

Post a sample DB with some fictitious data and we'll see what can be done to at least point you into the right direction or a direction of some sort.

.