472,352 Members | 1,507 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,352 software developers and data experts.

Bill of Material Module

Dear fellows , I'm quite new in database development and got already a project where I just found that I have to swallow an elephant in order to get it done ....
Being an owner of small manufacturing unit I'm struggling to make an application by myself to mimic MRP/ERP systems or at least part of it using Ms Access.
Question that I have refers to:
How to built a Bill of Material module (later on how to view it /explosion parts/ , edit and use components to find their multiple parents-so called "parts implosion")
In standard BOM we have parents and components in multilevel fasion, assemblies and subassemblies and there are all interconnected by relationship rules.

Any developer had similar project ? I need just a guidelines how to start and what objects will be proper to use.

Thanks in advance
Nov 28 '06 #1
6 19088
32,511 Expert Mod 16PB
I hope someone may be able to point you in the right direction, but this seems altogether too large a question to deal with here, Even if only guidelines are required.
As I say, I hope you get something helpful.
Nov 28 '06 #2
Hi DToronto,

I have done many project which I had to create "Where used", "Explode a BOM", etc. I find that the simple database structure is to have 1 table for a Part Master List (tblPartMaster) and 1 table for the BOM (tblPartBOM). This would allow you to have unlimited levels to a BOM.

tblPartBOM table would have these basic columns (you can add more if needed):

Assembly Part Number (AssyPN),
Component Part Number (CompoPN),
Quantity per assembly (QPA).

AssyPN is the Make Part and the CompoPN is the 1st level components/sub assemblies used (at this point component and sub assemblies are the same, if a CompoPN appears in other records as AssyPN then you know this it is a sub assembly. Also, if you do a query SELECT DISTINCT AssyPN FROM tblPartBOM, this would return a list of all your Finish and Sub Assembly Parts).

You will have to use some kind of recursing code to read it. To manage it, I would extract the top level BOM of a Part into a temporary table allow changes and then write back. This is not necessary the best and could be tricky especially if you have multiple users.

For reporting a BOM Part, again I would use a temporary table were you would extract all relevant records including the different levels and then call a report using this temporary table as it recordsource.

I hope this helps.
Nov 28 '06 #3
Hi Fishbite , I'm quite impressed. This is exactly what I'm looking for

Thank you for your time. I really appreciate your help

p.s. Any suggestion on 'recursing code' ?
Nov 28 '06 #4
32,511 Expert Mod 16PB
Recursing code works well with hierarchical structures.
A procedure that processes a single generation can call itself for the next lower level.
You need to follow that pattern while writing recursive procedures.
Nov 29 '06 #5
If all you want is a BOM module then you may not need an aversized ERP/MRP solution. Take a look at miniMrp.


Here's some ad copy from their website

miniMRP is a new, easy to use inventory manager with some additional features usually only found in larger ERP/MRP systems.

why maintain an overweight, over-complex ERP/MRP system when all you really want is something that will manage an unlimited number of inventory items and when required, build, manage and cost single and multilevel parts lists and Bill of Material of almost any number of levels or complexity
Sep 27 '07 #6
Oh, I forgot to say that the back-end database for miniMrp is a standard MS JET database file (same format as MS Access) so although miniMrp is not based on MS Access you can still us MS Access to add more forms and reports if you feel like expanding on what is already a real neat solution.
Sep 27 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Matthew Ferri | last post by:
Hi, Summary: I'm a newbie to FrontPage and IIS. I have a simple issue that I believe may be a configuration setting somewhere. If there is...
by: Gary Manigian | last post by:
I have 2 tables, one-to-many, that contain bills of material(BOMs): tblBOM: lngBOMID (PK) strAssemblyPartNo strDescription tblBOMDetail:...
by: abcd | last post by:
I am looking for ASP.NET 2.0 reading materials...may be any evaluation Free e-books....... If anybody knows pls post the links... Thanks ...
by: acharuku | last post by:
PLease help!! I want to keep track of material I have at my hospital. 1. We purchase material on monthly basis 2. We give material to...
by: contactmayankjain | last post by:
Hi every body. I have worked very hard to find out some of the very good material which is available on net and have put it in one place....
by: =?Utf-8?B?Sm9zdWZm?= | last post by:
Hi: I've been using MSN Bill Pay for years to pay my bills. I recently decided to look into Microsoft Money as I wanted a desktop application to...
by: xtopia | last post by:
Hi Guys I'm a novice access VBA programmer. Iím trying to write a nested query to explode the bill of material. But the BOM table has more than 20...
by: xtopia | last post by:
Hi Guys I'm a novice access VBA programmer. Iím trying to write a nested query to explode the bill of material. But the BOM table has more than 20...
by: henry | last post by:
Folks: Using Dreamweaver CS3... Consider a home page, "index.php" which conditionally REQUIREs one of 'N' HTML files of pure content. All site...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.