OK. I will see if I can get this to what I can do
It all makes sense except for this:
SELECT *
FROM tblFoods
LEFT JOIN relFoods_Brands ON tblFoods.ID = relFoods_Brands.Parent_ID
LEFT JOIN tblBrands ON tblFoods.BrandID = tblBrands.BrandsID LEFT JOIN tblClass ON relFoods_Brands.Parent_ClassID = tblClass.ClassID
I have no idea where thats supposed to go or what it does. Like I said im completely new to databases.