[AccessD] BOM - Table Structure For Handling Common Parts In Various Assemblies/Sub-Assemblies.

    Typical fields for a table having hierarchical list of assemblies and parts are observed to include:  ItemID, ParentID, Description, Qty

    With this arrangement, the complete hierarchical chain from each topmost item (having no immediate parent) downward can be worked out right upto the lowest part (having no child).

    In situations where a part with same ItemID is needed for more than one Item chain (i.e. more than one top parent), the above table structure might not prove adequate. 

    Any suggestions - while retaining its role as a self contained table ?

Best wishes,
A.D. Tejpal
------------