Gram123
Thread Starter
- Joined
- Mar 15, 2001
- Messages
- 1,829
Hi.
I have a database used for reporting company purchases. Each purchase type has a 6 digit code. I have been asked to add an extra level of detail to the database to improve the accuracy of identifying the purchases.
There are about 60 purchase types, and I've been asked to add unique 'sub-types' to a handful of those types. In other words I'll have:
Type 1
Type 2
___sub-type 1
___sub-type 2
___sub-type 3
Type 3
Type 4
Type 5
Type 6
___sub type 4
___sub-type 5
...and so on...
Is there a simple way to add this 'next level' to the main table? The outer 'type' field in the main table uses a lookup table (which appears as a drop down menu / combo box on the various forms). Would it be done with some kind of sub-table, or with a group of lookups from the Types table for each Type that has a sub-type?
Am I making any sense??!!
After I get passed that, I'll also have to include the sub-type code field in a number of forms (which already contain subforms).
Ideally, the sub-types that would appear in the drop-down menu would be dependent on whichever type had just been entered - in other words, using the exxample above, say type 6 was selected, I'd like the only available options in the sub-type code drop-down list to be sub-type 4 or sub-type 5.
Then come the queries and advanced reports.... I just need to get this started, so any ideas are hugely appreciated.
Gram
I have a database used for reporting company purchases. Each purchase type has a 6 digit code. I have been asked to add an extra level of detail to the database to improve the accuracy of identifying the purchases.
There are about 60 purchase types, and I've been asked to add unique 'sub-types' to a handful of those types. In other words I'll have:
Type 1
Type 2
___sub-type 1
___sub-type 2
___sub-type 3
Type 3
Type 4
Type 5
Type 6
___sub type 4
___sub-type 5
...and so on...
Is there a simple way to add this 'next level' to the main table? The outer 'type' field in the main table uses a lookup table (which appears as a drop down menu / combo box on the various forms). Would it be done with some kind of sub-table, or with a group of lookups from the Types table for each Type that has a sub-type?
Am I making any sense??!!
After I get passed that, I'll also have to include the sub-type code field in a number of forms (which already contain subforms).
Ideally, the sub-types that would appear in the drop-down menu would be dependent on whichever type had just been entered - in other words, using the exxample above, say type 6 was selected, I'd like the only available options in the sub-type code drop-down list to be sub-type 4 or sub-type 5.
Then come the queries and advanced reports.... I just need to get this started, so any ideas are hugely appreciated.
Gram