Your scenario is somewhat confusing, mainly because you're using the name 'sub-parts' for what appear to be different components used in different points in the manufacturing. Just to be clear would the scheme be
Products
|
Subpart1s
|
Raw Materials & Subpart2s
where Raw Materials and Subpart2s both being used to make up Subpart1s, which in turn are used to make up Products?
Or would it be
Products
|
Subpart1s
|
Subpart2s
|
Raw Materials
where Raw Materials are used to make up Subpart2s, then Subpart2s make up Subpart1s, which in turn are used to make up Products?
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007