dropdown to set multiple query filter criteria

[soulpiercing]

I am currently working on a criminal justice tracking program for the US Army. The structure of our legal office is set up in a way that we can all use a centralized database which will make reports and tracking at all levels easier but there is an issue I am trying to resolve.

Our office structure looks something like this:

MAIN legal office

1st Sub office

2nd sub office

3rd sub office


What I want to do, is on my main screen have a drop-down list of these offices (based on a table "offices"). Depending on the selection from this list, I want a filter to be applied to ALL queries so that if I work in the 2nd sub office - the cases from my office are all I see.

In every case, there is a selection of "unit" and in the unitdata table, the sub office is selected from "offices"

The main office would be set to view ALL data with no filters.

Issues:
this program will likely be used in other stations as well so the names of the sub offices will change as will the number of sub offices.

Ensure Key numbers are assigned regardless of which filter is in place. (shouldn't really be an issue).

Thanks for any help.

 

[DES]

Well SGT

It looks like you have a number of interesting things going on there. However you have not told us what the problem is. Kinda hard to help if we don't know what you need. Unless of course you are looking for somebody to make it for you.

If you just want somebody to talk to about it you can email me or find me on MS Messenger at technoweenie@sympatico.ca

DES

 

[soulpiercing]

This was actually a multiple post and I think I am making some progress off suggestions from the other posting located HERE.


Thanks - I'll probably still try to catch you on MSN sometime.