I create query for cascade combo boxes:
The criteria in this query include parameters: Facility, Building, Wing, Floor. How to modify the query if not all Facilities have Buildings with Wing? How to keep cascade boxes workable in case if will skipped Wing value?
SQL:
SELECT tblLocations.LocationID, tblLocations.FacilityID, tblLocations.BuildingID, tblLocations.WingID, tblLocations.FloorID, tblFacilities.Facility & " " & tblBuildings.Building & " " & tblWings.Wing & tblFloors.Floor & "-" & tblLocations.Room AS Location
FROM tblWings INNER JOIN (tblFloors INNER JOIN (tblFacilities INNER JOIN (tblBuildings INNER JOIN tblLocations ON tblBuildings.BuildingID = tblLocations.BuildingID) ON tblFacilities.FacilityID = tblLocations.FacilityID) ON tblFloors.FloorID = tblLocations.FloorID) ON tblWings.WingID = tblLocations.WingID
WHERE (((tblLocations.FacilityID)=[Forms]![fRequest]![cboFacility]) AND ((tblLocations.BuildingID)=[Forms]![fRequest]![cboBuilding]) AND ((tblLocations.WingID)=[Forms]![fRequest]![cboWing]) AND ((tblLocations.FloorID)=[Forms]![fRequest]![cboFloor]));
Last edited: