Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to make Product Structure?
- Thread starter Jar80
- Start date
Most likely you are going to have a Bill-of-Materials situation ie a heirarchy of things comprised of lesser things. This is not easy to do in Access. Have a look at Help regarding two levels of subforms (I think that's the maximum Access will do for you without you having to code).
You may have all your products and components in one table which is joined recursively to generate the heirarchy. If so make sure you use queries and not base tables for your forms.
The reason it's not easy to do is SQL is declarative. It likes "define RelationC which is a combination of Relation A and RelationB". What you need is "Keep on building RelationC an unknown number of times until PartialRelationX is empty".
You may have all your products and components in one table which is joined recursively to generate the heirarchy. If so make sure you use queries and not base tables for your forms.
The reason it's not easy to do is SQL is declarative. It likes "define RelationC which is a combination of Relation A and RelationB". What you need is "Keep on building RelationC an unknown number of times until PartialRelationX is empty".
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Question