Need SERIOUS HELP!!!

[GiD]

Could someone out there write me a very small program that meets these criterias. I HATE to resort to this ( I wanted to do it myself) but I can't find anyone out there that can do it???

Create a database that has three tables
[Table 1 Fields]
CatID = Autonumber
Category = Text

[Table 2 Fields]
SubID = Autonumber
Sub Category = Text
CatID = Number (This is how I am relating the tables)

[Table 3 Fields]
ItemID = Autonumber
Item Description = Text
Quantity = Number
Price = Currency
SubID = Number

Ok no to the Visual Basic 6.0 Part

I have a combo box called combo1, and two list boxes called list1 and list2

I want the contents of the Category field in the table categories to go into the combo box. And when I select one of the categories I want the sub categories related to that category to be displayed in list box list1. And finally when I click on a sub category in list1 I want the items for that sub category to be displayed in list box two.

Can ANYONE show me how to do this PLEASE! I am desperate! Thanks for your time

[preeti]

YOU ALREADY HAVE HALF OF IT DONE. DON'T GIVE UP NOW.

If you want, email me your code and I will HELP you fix it.

Preeti

[email protected]