-
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 :)
-
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]
