Roles Query:
Code:
SELECT DISTINCT tblPersonnel.First_Name, tblPersonnel.Last_Name, tblTrainingList.TrainingTitle
FROM tblTrainingList INNER JOIN (tblPersonnel INNER JOIN ((refTblTrainingGroups INNER JOIN ((refTblRoles INNER JOIN refJunctTblGroupToRole ON refTblRoles.RoleID = refJunctTblGroupToRole.RoleID) INNER JOIN refJunctTblPersonnelToRole ON refTblRoles.RoleID = refJunctTblPersonnelToRole.RoleID) ON refTblTrainingGroups.GroupID = refJunctTblGroupToRole.GroupID) INNER JOIN refJunctTblTrainingToGroup ON refTblTrainingGroups.GroupID = refJunctTblTrainingToGroup.GroupID) ON tblPersonnel.PersonnelID = refJunctTblPersonnelToRole.PersonnelID) ON tblTrainingList.TrainingID = refJunctTblTrainingToGroup.TrainingID
WHERE (((tblPersonnel.PersonnelID)=[Forms]![frmMain]![lbxPersonnel]))
ORDER BY tblTrainingList.TrainingTitle;
Teams Query:
Code:
SELECT DISTINCT tblPersonnel.First_Name, tblPersonnel.Last_Name, tblTrainingList.TrainingTitle, tblPersonnel.PersonnelID
FROM tblPersonnel INNER JOIN refJunctTblPersonnelToTeam ON (tblPersonnel.PersonnelID = refJunctTblPersonnelToTeam.PersonnelID) AND (tblPersonnel.PersonnelID = refJunctTblPersonnelToTeam.PersonnelID) AND (tblPersonnel.PersonnelID = refJunctTblPersonnelToTeam.PersonnelID), tblTrainingList INNER JOIN refJunctTblTrainingToTeam ON (tblTrainingList.TrainingID = refJunctTblTrainingToTeam.TrainingID) AND (tblTrainingList.TrainingID = refJunctTblTrainingToTeam.TrainingID)
WHERE (((tblPersonnel.PersonnelID)=[Forms]![frmMain]![lbxPersonnel]));
Ad Hoc Query:
Code:
SELECT DISTINCT tblPersonnel.First_Name, tblPersonnel.Last_Name, tblTrainingList.TrainingTitle, tblPersonnel.PersonnelID
FROM tblTrainingList INNER JOIN (tblPersonnel INNER JOIN refJunctTblAdHocTrainingToPersonnel ON tblPersonnel.PersonnelID = refJunctTblAdHocTrainingToPersonnel.PersonelID) ON tblTrainingList.TrainingID = refJunctTblAdHocTrainingToPersonnel.TrainingID
WHERE (((tblPersonnel.PersonnelID)=[Forms]![frmMain]![lbxPersonnel]));