AHh okay I understand how you mean.
The way the tables relate initially is by the CID then the PID For the sub categories like I said I have SID | PID | CID
The PID and the CID Relate to the correct fields and the SID is a unique auto_incremented number
Say for instance I have
1 | CategoryName in the Category Table
1 | 1 | ProductName Product Table
1 | 1 | 1 | SubCategoryName in the SubCategory table
The relationship is really by the CID and PID
Is that correct or wrong?