Access Bill of Materials accounting and Northwind

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

I have built a simple accounting system in Access  and modelled it around Northwind. I have
modelled the inventory part very much around Northwind. I now need to build a Bill of Materials component.

Does anyone know whether Northwind does this? Any recommendations on how to go about it would be greatly appreciated.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Commented:
Northwinds doesn't contain BOM features.

BOM is, essentially, a Master-Child setup. You would have a table to store your BOM "Header", and then a table to store each component of that "header" (the "detail" table).

Some setups I've seen incorporate a "Bill_Of_xxx" table, like a Bill_Of_Jobs. This would store data about the 'root' job, and each "component" job, along with that component's "parent" job. This allows for a recursive structure, where a BOM "component" could also be a "parent".

This is typically represented in Access as a Form-Subform relationship.
Murray BrownASP.net/VSTO Developer

Author

Commented:
Thanks very much.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial