Relationship

[pcandns]

I just want to make sure that I am doing correctly



I have four tables as of now eventually will be more.

First Table tblUnit - Fields [UnitID], [Unit], and [UnitDescription]
Second Table tblPriSys - Fields [PriSysID], [PrimarySystem], [PriSySDescription], and [fUnitID]
Third Table tblSystem - Fields [SystemID], [System], [SystemDescription], and [fPriSysID]
Fourth Table tblPressureTest - Fields [HydroTestID], [HydroTestPressure], [funitID], [fPriSysID], and [fSystemID]
The other tables that I will add will be like the fourth table, and will have to have the UnitID, SystemId, and PriSysID

There will be one unit which may have several Primary Systems and One Primary System for several Systems, one system for every hydro, one system for every other table that I will be adding, which will all need to be tracked by Unit, PriSys, and System

My Relationship is as
tblUnit(1), tied to (many)tblPrisys(1), tied to (many)tblSystem

is this correct so far, and how do I need to tie my hydro relationship into all three tables?
Thanks

[rommelgenlight]

if you mean hydro for your tblPressureTest Table then

1. You can tie it each to its fUnitID, fPriSysID, FSystemID
or
2. since table 1 is connect to table 2 thru unitID and table 2 is connect to table 3 thru PriSysID then you have already connected the table 4 to table is thru using SystemID.

[pcandns]

Thanks for the reply
I change the pressureTest(hydro) table to relate to system ID thanks.
If data is entered into the pressuretest table I will need to count items, I can not get this to work right
What is the best way to do this.
Currently I have this
qrypressure with all items from all tables in query The items that I wanted counted are
unit, Primary System, and System Report should look like this

Unit | PrimarySystem       | System     |  # of HydroTest
A2            PG                SG                3
                                 SWG              6
              AS                 SO               4
A3            AGB               AQW               1
 
Grand Total
2               3                   4              14

What is the best way. Please lead me in right direction.