Code:
SELECT tblProductInfo.ProductID, tblProductInfo.ProductNumber, tblProductInfo.ProductDesc1, tblProductInfo.ProductDesc2, tblPhase.PhaseDesc, tblPhase.IntendedUse, tblProductInfo.Effective, tblProductInfo.DateUsed, tblFish.FishDesc, tblFish.ScientificName, tblPack.PackDesc, tblCustomers.CustomerDesc, tblBrand.BrandDesc, tblProductInfo.ShelfLife, tblCut.CutDesc, tblSauce.SauceID, tblSauce.SauceNumber, tblSauce.SauceDesc1, tblSauce.Amount, tblSauce.Ingredients, tblSauce.InjectorSettings, tblFilm.FilmNumber, tblFilm.FilmDesc, tblFilm.Film2Number, tblFilm.Film2Desc, tblFilm.FilmTemperature1, tblFilm.FilmTemperature2, tblFilm.FilmTare, tblRetailCase.RetailCaseNumber, tblRetailCase.RetailCaseDesc, tblRetailCaseType.RetailCaseTypeTare, tblRetailCaseType.RetailCaseTypeWeight, tblRetailCaseType.RetailCaseTypeUnits, tblMasterCase.MasterCaseNumber, tblMasterCase.MasterCaseDesc, tblMasterCase.MasterCasePalletConfiguration, tblMasterCaseType.MasterCaseTypeWeight, tblMasterCaseType.MasterCaseTypeUnits, tblMasterCaseBottom.MasterCaseBottomNumber, tblMasterCaseBottom.MasterCaseBottomDesc, tblDivider.DividerNumber, tblDivider.DividerDesc1, tblComponent.ComponentNumber, tblComponent.ComponentDesc1, tblLabel.LabelNumber, tblLabel.LabelDesc, tblFilm.FilmDesc2, tblProductInfo.FilmPocket, tblProductInfo.FilmCoding, tblProductInfo.RetailCoding, tblProductInfo.PortionMinWeight, tblProductInfo.PortionMaxWeight, tblProductInfo.PortionTargetWeight, tblProductInfo.SpecialInstructions, tblProductInfo.SpecialInst, tblProductInfo.ImagePath
FROM tblSauce RIGHT JOIN (tblRetailCaseType RIGHT JOIN (tblRetailCase RIGHT JOIN (tblPhase RIGHT JOIN (tblPack RIGHT JOIN (tblMasterCaseType RIGHT JOIN (tblMasterCase RIGHT JOIN (tblMasterCaseBottom RIGHT JOIN (tblLabel RIGHT JOIN (tblFilm RIGHT JOIN (tblDivider RIGHT JOIN (tblCut RIGHT JOIN ((tblCustomers LEFT JOIN tblBrand ON tblCustomers.CustomerID = tblBrand.CustomerID) RIGHT JOIN (tblComponent RIGHT JOIN (tblFish RIGHT JOIN tblProductInfo ON tblFish.FishID = tblProductInfo.Fish) ON tblComponent.ComponentID = tblProductInfo.Component) ON tblCustomers.CustomerID = tblProductInfo.Customer) ON tblCut.CutID = tblProductInfo.Cut) ON tblDivider.DividerID = tblProductInfo.Divider) ON tblFilm.FilmID = tblProductInfo.Film) ON tblLabel.LabelID = tblProductInfo.Label) ON tblMasterCaseBottom.MasterCaseBottomID = tblProductInfo.MasterCaseBottom) ON tblMasterCase.MasterCaseID = tblProductInfo.MasterCase) ON tblMasterCaseType.MasterCaseTypeID = tblMasterCase.MasterCaseType) ON tblPack.PackID = tblProductInfo.Pack) ON tblPhase.PhaseID = tblProductInfo.Phase) ON tblRetailCase.RetailCaseID = tblProductInfo.RetailCase) ON tblRetailCaseType.RetailCaseTypeID = tblRetailCase.RetailCaseType) ON tblSauce.SauceID = tblProductInfo.Sauce
WHERE (((tblProductInfo.ProductNumber)=[Item Number]));