The Bill of materials processor is designed to allow you to decompose
an assembly into its component items. it operates at multiple levels where each item at
each level can be a component or a sub-assembly. (SubAssemblies are further decomposed by
This processor uses 3 tables:
Table 1: Assemblies contains the list of items needed
to assemble any assembly the items can be subassemblies or components. It comprises the
||a text field to allow the user to recognise the item.
||a code field to allow linking.
||The number of units required for this level of this assembly.
For a given assembly, the items that go into its construction are entered into the
ComponentID field, while the parentID contains the code identifying the given assembly.
Table 2: Components contains the list of items
recognised by the Assemblies Table. Comprises the following fields
||a unique key, identifying the component
||describes the component
||to identify whether this is an assembly which has a breakdown entered in
the Assemblies Table.
Table 3, the Output Table is a variable purpose table
which, in this example, identifies the components and the number required to construct any
assembly. Comprises the following fields
||the same format as the Component Table.
||A Count of the number of items required.