Bill of Material Processor

[Guest]

I am writing a simple Bill of Material processor supporting multi-level bills
using Visual Basic. I need a quick way to ensure that any given part is not
used on itself at any level above the level currently being entered?

I am trying to avoid testing each where used string as this can become very
complicated. Any suggestions?

 

[Allen Browne]

To list only parts that are not part of a subassembly, use a query with a
subquery in the WHERE clause.

If subqueries are new, see:
How to Create and Use Subqueries
at:
http://support.microsoft.com/?id=209066

 

[Guest]

Allen:

Thanks for your feedback. I will probably need to assign low level codes to
know when I've reached the top.

David S.