Bill, That idea crossed though my mind as well. These all are at least giving me hope I can finally get what I want. It is just a matter of trying the different suggestions. Fun for the holidays.
James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, November 25, 2015 10:49 AM To: Jim Belisle Subject: [RBASE-L] - RE: BOM 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]<mailto:[email protected]>> Date: Wed, November 25, 2015 10:57 am To: [email protected]<mailto:[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]]
