Jim
You may want to use an exploding BOM.
Finished Goods table w/Model# then;
Parts Used Table
Sub-Assembly Used Table - includes Parts and other sub-assemblies used
Assembly Used Table - includes Parts, Assemblies, Sub-assemblies used
Linking column for all tables being the Model# in all 4 tables.
Populate and Build each Model# using parts, sub-assemblies and assemblies.
Then create a report based on a view that when the Model# is entered, will produce a Bill Of Materials list for the Model#.
Sorry if you already know this stuff but sometimes an explosion can be enlightening.
Bill Eyring
LAMP Software, Inc.
-------- Original Message --------
Subject: [RBASE-L] - BOM
From: Jim Belisle <[email protected]>
Date: Wed, November 25, 2015 10:57 am
To: [email protected]
For years we have costed our products with a simple report just throwing together all parts making up a product not worrying about using an indented BOM.
We would like to go to an indented BOM.
Right now it is just
Model# then all parts making up the model.
We want something like this:
Level 1: Model#
Level 2: Assemblies and parts we ship
Level 3: Sub assemblies (or parts if no subs) making up the assemblies.
Level 4: Parts making up the sub assemblies.
I can get it so all assemblies are together and then all subs together by assigning a BOMtype to them.
So it will be:
Assy
Assy
Assy
Sub assy
parts
Sub assy
parts
Sub assy
Parts
That is not however what we want. I just can't seem to figure the proper way to handle this.
Any blues clues would be appreciated.
James Belisle
Making Information Systems People Friendly Since 1990
[cid:[email protected]]
