Newbies Claude Sebastien Posted September 14, 2007 Newbies Share Posted September 14, 2007 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 More sharing options...
bruceR Posted September 16, 2007 Share Posted September 16, 2007 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 More sharing options...
daltwin Posted September 16, 2007 Share Posted September 16, 2007 Hi, Sounds like you're treating your bill of materials table as a line items table for your invoices? If so, it's INVOICES --- BOM --- PRODUCTS Link to comment Share on other sites More sharing options...
The Shadow Posted September 17, 2007 Share Posted September 17, 2007 I have a simple BOM example I threw together a while ago. BilloM.fp7.zip Link to comment Share on other sites More sharing options...
Newbies Landin Posted September 24, 2007 Newbies Share Posted September 24, 2007 Shadow, 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 Bike --Wheel ----Tire ----Spoke ----Rim --Frame --Seat Link to comment Share on other sites More sharing options...
The Shadow Posted October 9, 2007 Share Posted October 9, 2007 Hi Landin, Sorry for the delay in response, I wasn't watching this thread. Here's a modification that supports the indented list as in your example, it's all done using unstored calculations though, so its not really going to fly for a 747's BOM though. :B BilloM.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6136 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 accountSign in
Already have an account? Sign in here.
Sign In Now