microsoft.public.access.forms

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


"Dennis" wrote:

> 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...?
>
> "Driss B." wrote:
>
> > 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
> >