Jump to content

Bill of Materials / Formula

This topic is 6103 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Ok. I'm a super neophyte newbie so please don't be too harsh with me. Only a few days with my head in the database world. At the moment I'm trying to work out basic relationships and I'm alright until I get to one table. On the one hand I've got all my Purchase Order data, and on the other I've got Invoice data. In the middle however, I've got a Bill of Materials, which is in essence a formula table. Each record describes a Parent Product Code Number, a Batch Quantity (almost always 1), Component Product Code Number, Quantity of Component Per Parent, and a Decimal Control Code. I am assuming this would be a Many-To-Many relationship conundrum. I need to relate cost data through the formula/bill of materials from the Purchase Order to the Invoice. I am assuming this is a fairly common exercise. Has anyone done this before, and if so how best do I structure this. Many thanks in advance.


Link to comment
Share on other sites

In general many to many is done through a join table. So for example a project system might have Projects and Employees and their would be a join table where each record has one project ID and one employee ID; plus in this case some kind of role or responsibility description.

Since your relation graph provides no detail on key fields it is difficult to help you, and I don't quite understand your explanation.

Link to comment
Share on other sites

  • Newbies


I have seen you simple BOM database before and it is very nice because it is the simplest way I have seen this done. I was wondering if you had a way to print it out in a second way. Instead of just seeing the first top level under the bike see all components listed for each part and indented to keep separate. So for example








Link to comment
Share on other sites

  • 2 weeks later...

This topic is 6103 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.