Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

Modules: Bill Of Materials

Author(s)
Robin Stoddart-Stones

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 the breakdown).

Download

Download BOM.Zip (Access 97 database)

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 following fields.

ComponentID a text field to allow the user to recognise the item.
ParentID a code field to allow linking.
NumberRequired 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

ComponentID a unique key, identifying the component
ComponentDescription describes the component
AssemblyBoolean 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

ComponentID the same format as the Component Table.
Number Required A Count of the number of items required.
   

1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer