Filtering a Form automatically

[bennybee]

I have a database which has a table Subject - which contains the values - Liquor, Tobacco, Kava etc.

I have another table which has decisions.

Now the database is supposed to store the specific decisions to complaints made about each different type of substance.

Thus i have another table called Decisions with the following details:
KAVA - Application approved
LIQUOR - Application Denied
etc.

it gets a little more complicated as each substance has a differing set of outcomes to a decision. e.g. a liquor application can be suspended but a kava one cannot.

I have a form with these two fields on it - the Substance field from the Subject table, and the Decision field from the Decisions table.

what i want is for my combo box to only display the relevant possible decisions based on the subject combo box.
so if you select Liquor from the first combo box, the decision combo box only displays the decisions for liquor.

is this possible or am i living in a distorted dream?

i need something like this as there are over 100 different types of decisions, if i group them all together, as there are 5 different substances, and 20 different decisions can be made for each (and as i said before, they can differ between substance).

so i need to be able to filter the combo box down to only show the details for a specific substance.

can someone offer some assistance, or another way to get aroudn it if you cant do what i want?

im sorry if this question has been asked before, i looked in the searching for cascading combos, but nothing seemed to address the same thing that i want - they are about subforms...
or maybe my n00bieness is just too great and im missing something..

please HELP!!

 

[R6Flyer]

bennybee

Could you post a 97 version of your database with just the relevant tables/forms - that way we can take a closer look at your problem.

You are on the right lines when you searched for cascading combo boxes and this is definitely the way to go.

Cheers

Flyer

 

[bennybee]

Hi again,.

this is a very simple sample of the database that im trying to create, with only the relevant tables included.

There are 3 tables, a Decision Table, a Subject Table and a Meeting_Agenda table.

The Subject table contains a list of all the possible substances that a meeting agenda could be related to - e.g. could be regarding a complaint about someones liquor licence.

The Decision Table contains all the different types of decisions that can be made for each substance. Each substance has a different set of decisions that can be made.
e.g. you can grant a full liquor licence, or a special liquor licence, but you can only grant a full kava licence. that kinda thing

and the Meeting_Agenda table is the table which the form is created on. the form has the two drop down boxes on it where the user first selects a subject.

The idea is that once the user selects a subject, only the decisions that are related to that substance are displayed, while the others are 'hidden'.
so if the user selects Liquor - only liquor related decisions are displayed in the combo box.

see whether you can make any sense out of this.
thanks for all your time

BB

My database will only compress to 160Kb and that is too big to post here it keeps on telling me.
so if you could please give me an email address, i could email it to you... thanks