Making categories

[john]

I have a lookup table with 3 fields that reprensents costs categories,
something like this:
Fld1 Fld2 Fld3
Holiday Malibu 2005 Hotel
Holiday Alps 2006 Hotel
Meeting Montly meeting Conference room

I want to use this lookup table in another table that has the same fields.
This table is in a form. For being able to look up the right value, my plan
is to run a query at the arrival at field 1 to filter the unique
possibilities of category 1. For field 2 I'd like to do something similar
but then filter out only the category 2 items that belong to the choice that
was made by the user in field 2. The same accounts for field 3 in relation
to field 1 and 2.
Is this normal practice in Access or is there a better alternative?
Thanks in advance,
john

[john]

If this is the right way to do it, how do I refill the lookupfields with the
right values since they only get filled once by the query when the form is
opened. How can I refill the lookup lists when the user sets focus to the
related field?
john

"john" <jo**@test.comschreef in bericht
news:OO******************************@casema.nl...

>I have a lookup table with 3 fields that reprensents costs categories,
something like this:
Fld1 Fld2 Fld3
Holiday Malibu 2005 Hotel
Holiday Alps 2006 Hotel
Meeting Montly meeting Conference room

I want to use this lookup table in another table that has the same fields.
This table is in a form. For being able to look up the right value, my
plan is to run a query at the arrival at field 1 to filter the unique
possibilities of category 1. For field 2 I'd like to do something similar
but then filter out only the category 2 items that belong to the choice
that was made by the user in field 2. The same accounts for field 3 in
relation to field 1 and 2.
Is this normal practice in Access or is there a better alternative?
Thanks in advance,
john

[Bob Quintal]

"john" <jo**@test.comwrote in
news:E7********************@casema.nl:

If this is the right way to do it, how do I refill the
lookupfields with the right values since they only get filled
once by the query when the form is opened. How can I refill
the lookup lists when the user sets focus to the related
field? john

"john" <jo**@test.comschreef in bericht
news:OO******************************@casema.nl...

>>I have a lookup table with 3 fields that reprensents costs
categories, something like this:
Fld1 Fld2 Fld3
Holiday Malibu 2005 Hotel
Holiday Alps 2006 Hotel
Meeting Montly meeting Conference room

I want to use this lookup table in another table that has the
same fields. This table is in a form. For being able to look
up the right value, my plan is to run a query at the arrival
at field 1 to filter the unique possibilities of category 1.
For field 2 I'd like to do something similar but then filter
out only the category 2 items that belong to the choice that
was made by the user in field 2. The same accounts for field
3 in relation to field 1 and 2.
Is this normal practice in Access or is there a better
alternative? Thanks in advance,
john

This is so common trhat there are 36,000 plus web pages devted
to the question of Cascading Comboboxes

Here's a good one
http://experts.about.com/q/Using-MS-...scading-combo-
boxes.htm
here's a sample database example.
http://www.utterangel.com/pages/acce...nloads.aspx#43
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[john]

"Bob Quintal" <rq******@sPAmpatico.caschreef in bericht
news:Xn*********************@66.150.105.47...

This is so common trhat there are 36,000 plus web pages devted
to the question of Cascading Comboboxes

Here's a good one
http://experts.about.com/q/Using-MS-...scading-combo-
boxes.htm
here's a sample database example.
http://www.utterangel.com/pages/acce...nloads.aspx#43

Thanks.
Point taken.
john