I use two tables for my indented BOM. One is the parts/assemblies with the descriptions and type.
The other contains the parentid childid, quantities and item#(used for balloons, grouping). I have routines that extracts the total quantities and sub assemblies. Dan -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, November 25, 2015 7:58 AM To: Dan Goldberg Subject: [RBASE-L] - BOM 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]]
