how do i synchronize more than 20 Combo Box in a form?

D

Driss B.

I have many fileds in a form, and i would like to make the combo box in
relation with each other, so that i can click on a combo box, to chose one
field value then i would filter the form based the that field value. then
pass to the next combo box and the list of the combo would be filtred too
based on the filter of the form. and so one for all the combo box i have
 
D

Dennis

I have never, in all my many years as a database designer, heard of ANY
application requiring TWENTY (20) cascading combo-boxes. Perhaps you might
explain a little more about your application...?
 
D

Driss B.

if you can give me an email i will send you some screen shot of an
application we have within my company that i am trying to creat some thing
similar to it.
any way..
i am building a databse for a stock (inventory)
but this inventory is special
i have many parameters that at many occasion two items in the inventroy can
have more than 20 characteristics similar and then only the 21st will make
them different
example
ine on record i can have many field such as ( Size, Weight Min, Weight Max,
Thread Up Size, Thread Down Size, Thread Up Weight Min / Max, Thread Down
Weight Min / Max, thechnical Name, Type, Model Designation, Grade of
Material....)
i work in the oil field and our tool need precise descriptions...
what i am trying to do is to be able to filtre my table through a form,
using Combo Box, to choose the field, and every time i would choose a field,
the form would execute a search to find the first record with that match.
then i would filter by selection the form, and so on with the next field.
i realy hope i was clear... i know it doesn't look like at all.
i hope you can help me
 
D

Dennis

[email protected]




Driss B. said:
if you can give me an email i will send you some screen shot of an
application we have within my company that i am trying to creat some thing
similar to it.
any way..
i am building a databse for a stock (inventory)
but this inventory is special
i have many parameters that at many occasion two items in the inventroy can
have more than 20 characteristics similar and then only the 21st will make
them different
example
ine on record i can have many field such as ( Size, Weight Min, Weight Max,
Thread Up Size, Thread Down Size, Thread Up Weight Min / Max, Thread Down
Weight Min / Max, thechnical Name, Type, Model Designation, Grade of
Material....)
i work in the oil field and our tool need precise descriptions...
what i am trying to do is to be able to filtre my table through a form,
using Combo Box, to choose the field, and every time i would choose a field,
the form would execute a search to find the first record with that match.
then i would filter by selection the form, and so on with the next field.
i realy hope i was clear... i know it doesn't look like at all.
i hope you can help me
Click to expand...
 
D

Dennis

After viewing your form, I now know what you're trying to do. You are
currently selecting a value in a combo-box, then right clicking in the box
and performing a "Filter by Value" for that control, which cuts down on the
number of records you have. Then you do that again in another combo-box,
which filters further. You repeat this for several combo-boxes.

I suggest you look into the "Query By Form" functionality available in
Access. Using that methodology, you select ALL combombox values you want to
filter/search on (and ONLY fill in those you want to use for the filter
process), then click the button to perform the filtering all at once. You'll
find that much easier than the manual method you're currently employing.
 
D

Driss B.

Well, this is how i first started... but the problem is i want that after
each time i select a combo box and ech time i filter the text box should the
other combo box be filtred too so that the user will be shown only relevant
option to choose and not other records that are not par tof the actual fiter.

as you most probably noticed in the pictures i have sent you. even the list
of items in the combo boxes is filtred each time each time i filter the form
with the text box

can you help me on this one,

thanks a lot
 
Top