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]

Re: Making categories

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" <john@test.coms chreef in bericht
news:OO6dnQm-eIhfXGfZnZ2dnUV Z8qKdnZ2d@casem a.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]

Re: Making categories

"john" <john@test.comw rote in
news:E7idnTIU4N aoW2fZRVnytw@ca sema.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" <john@test.coms chreef in bericht
news:OO6dnQm-eIhfXGfZnZ2dnUV Z8qKdnZ2d@casem a.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-Access-1440/cascading-combo-

boxes.htm
here's a sample database example.

http://www.utterangel.com/pages/access_downloads.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]

Re: Making categories

"Bob Quintal" <rquintal@sPAmp atico.caschreef in bericht
news:Xns98335C1 167AFBQuintal@6 6.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-Access-1440/cascading-combo-

boxes.htm
here's a sample database example.
http://www.utterangel.com/pages/acce...nloads.aspx#43

Thanks.
Point taken.
john