Ok so I have a table tblSite that has about 6 lookups to a staff table tblSiteStaff.
This is so I can add in multiple staff into a Mail Merge, but anyhow my SQL is as follows:
Its simple, I would be able to pull all the details for each staff memeber and Access should just add _1, _2 etc to the end of the field names.
The issue is that as soon as I add in the second staff table relationship the query fails to return any staff detals...
Ideas?
This is so I can add in multiple staff into a Mail Merge, but anyhow my SQL is as follows:
Code:
SELECT tblSite.*, tblSiteStaff.*, tblSiteStaff_1.*
FROM (tblStateProvince INNER JOIN (tblSiteStaff RIGHT JOIN tblSite ON tblSiteStaff.SiteStaffID = tblSite.PrimaryContact) ON tblStateProvince.StateProvinceID = tblSite.fk_StateProvinceID) LEFT JOIN tblSiteStaff AS tblSiteStaff_1 ON tblSite.MergePrimaryAuditor1 = tblSiteStaff_1.SiteStaffID;Its simple, I would be able to pull all the details for each staff memeber and Access should just add _1, _2 etc to the end of the field names.
The issue is that as soon as I add in the second staff table relationship the query fails to return any staff detals...
Ideas?
