![]() Some Parts are a composite that may include one or more drawings. Since parts and drawings require different pieces of info, I don't see combining them. ![]() Should I combine parts and drawings into a single table, or does any one have some suggestions? I doubt if a BOM template will help. Access Database Or Template To Record Liabilities By Contract And.ĭiner dash 2 play online free. This Microsoft Office Access file size is 1280 kb. This ms access database templates works on Access 2010 and available for free as Access 2010 Templates. Table: Bom Detail Fields: (PK) Part Number, (PK) Dwg Number, qty, item num HAs briefly mentioned earlier, some drawings are listed on other drawings, and therefore parts.ĭownload Access Database Inventory Management Templates Examples. So my question is, has anybody ever developed a schema for a bill of materials, and if so what is the best route to take? Urrently: Table: Parts Fields: (PK) Part Number, Description, Mfg, Mass, Material Table: Drawings Fields: (PK) Dwg Number, Description, Rev, Sheets, Date, Engineer, etc. Now I am having trouble, as some parts are also drawings and people must enter the drawing and then enter the same info as a part. Orginally I had thought that a drawing and part were seperate pieces in the scheme of things. Ok, I was wondering if I might be able to ask for some advice? I have created a database to store a bill of materials for several drawings.
0 Comments
Leave a Reply. |