table design help

[erick-flores]

Hello all

I need some help in designing tables so I wont have problems doing
finals reports

Background:

Compressor manager interface. An interface that will do surveys from
compressors.
There is a Location, each location can have multiple compressors. Each
compressor can have multiple stages. Each stage can have multiple
cylinders.
Cylinders can have multiples: five components (1) valve asb, (2)
packing case, (3) gaskets, (4) piston rod and (5) unloaders.
valve asb can have comp valve partes
packing case can have (1) cups and (2) packing case parts.
packing case
parts can have packing set details
piston rod can have (1)compressor rods, (2) nuts and (3) pistons
pistons can have (1) piston
rings and (2) rider rings

Basically the user will be filling forms of what their compressors
have.

I have already build this application but I cant create the right
report. At the moment of displaying the right groups. The groups for
the report should be as follow:
Header: Compressor ID
Group1: Stages ID
Group2: Cylinder ID
Group3: components of cyinders
Group4: components from components of cylinders

I can get the Group 3 and 4 to work/display. I am almost sure because
of the design of my tables. Right now I have 18 tables, each table have
their own PK and FK to link the tables. Each relationship is from
one-to-many.

My question is: what would be the best way to design my tables so I can
display the report I want?

Thank you in advance

 

[Dos Equis]

Not that I'm an expert by any means but it seems to me that you need to
design your querys to display the info you want and run your reports
from there. Sounds like you are simply listing data so I would think
that a query designed to pull data from multiple tables would suit your
pourpose.

 

[Dos Equis]

Not that I'm an expert by any means but it seems to me that you need to
design your querys to display the info you want and run your reports
from there. Sounds like you are simply listing data so I would think
that a query designed to pull data from multiple tables would suit your
pourpose.