Hi,
I have a question...
First of all, here's what my database looks like:
Tables
ItemsTable
Item ID
Item Key
Item Keyword
Item Text
GeneralInfoTable
Item ID
Item Author
Date
CaseTable
Item ID
Case Text
Case Title
GraphicsTable
Item ID
Graphic (OLE object)
Graphic Title
All of them are linked by Item ID
This is what I want to do.....
When the program starts, a switchboard pops up.
It has the following:
Add Item Classification
Add Item (only available after Item Classification has been entered)
When you click Item Classification, I want the user to enter their own unique item classification.For example, say the person will enter the following:
Level 1: Math, Science
Level 2: If Math, then Algebra-----If Science, then Chemistry
Level 3: If Algebra, then Binomail Expansion-----If Chemistry, then Combined Gas Law
Where would these be stored? tblItemClassification 1(ICL 1), tblICL 2, and tblICL3?
(when he is done entering the data, he will go to add item and the form will contain 3 Combo Boxes)
If he picks Math in Combo Box 1, then Algebra is the only choice in Combo Box 2.
If he picks Science in Combo Box 1, then Chemistry is the only choice in Combo Box 2.
I can't just write a code such as "If Combo1.Value="Math" Then Combo2.Value="Algebra"" because the data will not be pre-entered, but the user will have to enter it. How would I go about doing this?
Thanks in advance!
I have a question...
First of all, here's what my database looks like:
Tables
ItemsTable
Item ID
Item Key
Item Keyword
Item Text
GeneralInfoTable
Item ID
Item Author
Date
CaseTable
Item ID
Case Text
Case Title
GraphicsTable
Item ID
Graphic (OLE object)
Graphic Title
All of them are linked by Item ID
This is what I want to do.....
When the program starts, a switchboard pops up.
It has the following:
Add Item Classification
Add Item (only available after Item Classification has been entered)
When you click Item Classification, I want the user to enter their own unique item classification.For example, say the person will enter the following:
Level 1: Math, Science
Level 2: If Math, then Algebra-----If Science, then Chemistry
Level 3: If Algebra, then Binomail Expansion-----If Chemistry, then Combined Gas Law
Where would these be stored? tblItemClassification 1(ICL 1), tblICL 2, and tblICL3?
(when he is done entering the data, he will go to add item and the form will contain 3 Combo Boxes)
If he picks Math in Combo Box 1, then Algebra is the only choice in Combo Box 2.
If he picks Science in Combo Box 1, then Chemistry is the only choice in Combo Box 2.
I can't just write a code such as "If Combo1.Value="Math" Then Combo2.Value="Algebra"" because the data will not be pre-entered, but the user will have to enter it. How would I go about doing this?
Thanks in advance!
