Master Parts/Sub Parts/Sub-Sub Parts 
Author Message
 Master Parts/Sub Parts/Sub-Sub Parts

I am building a pdoxwin 5 application for a manufacturer that requires
each part to use components, and each component to use sub-component.  I
am currently maintaining multiple tables along the lines of:

Master Part (keyed on MasterID)
Master Details (keyed on MasterID + SubID)
Sub Details (keyed on MasterID + SubID + SubSubID)

Each component is an inventory item taken from an inventory table.

Where I'm having massive problems is in the management.  The master part
must have costs built from all components, but quotes and invoices can't
show the cost and component breakdown.  this means lots of complex
queries and calulations and complex forms for showing detail tables and
detail-detail tables, and lots of long OPAL methods for correctly
updating, deleting, duplicating etc. on the multiple tables.

The Question:  Am I just getting what I deserve, and this is why
manufacturing software is so expensive?  or is there something i'm
missing in the use of the 3 tables described above, since this model
limits me to 3 levels of assembly.


dan zucker
Parallax Computer Services

Fri, 21 Aug 1998 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Type, sub-type, and sub-sub-type database design

2. How to make calculations based on several summary fields included in a sub-summary part

3. FileMaker Pro 3.0 Problem 1 (Sub-summary part)

4. Profile of of a DBA - part System Admn / Part Network Admin / Part Web Admin

5. precision parts, bicycle parts, optical parts, electronic components

6. Sub queries <> sub tablesl

7. Query using UDF joined to a sub query vs Temp Table to sub Query

8. How do I implement sub sub filters ??

9. Pick Archive - PAR.SUB source code - par.sub (1/1)

10. Pick Archive - PAR.SUB source code - par.sub (0/1)

11. Need Help! Sub-totals within Sub-Totals

12. How can I extract sub-total from a sub-report into the main report

Powered by phpBB® Forum Software