Combo Box selection pointing to a table for a Second Combo Box

[Guest]

I have a form that I use to input data into a table. In that form I have a
combo box, linked to a table I call categories. I have a second combo box in
the same form. I would like to use the first box to direct the second box to
a particular table. For example:
The first Combo Box is a category. So if I chose fruits in the first box, I
would want to be able to choose from a list of fruits(from an existing table)
in the second box. If I chose vegetable in the first box, it should direct
the second box to a list of vegetables and so on...

Is this possible?

 

[tina]

well, yes, it can be done, but first a question about your table design: do
you have "fruits" records in one table, and "vegetables" records in another
table? if so, there's a good chance that your table design is not
normalized; for more information about data normalization, see
http://home.att.net/~california.db/tips.html#aTip1.

hth