Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
SELECT A.AssignmentID, R.Rate FROM (tblMalpracticeLocations L INNER JOIN tblAssignments A ON L.LocationID = A.MPLocation) INNER JOIN tblMalpracticeRates R ON (L.TerritoryID = R.TerritoryID) AND (A.MPSpecialty = R.SpecialtyClassID) ORDER BY A.AssignmentID;
DLookup("Rate", "tblMalpracticeRates", "(SpecialtyClassID = " & Forms![frmAssignments]!MPSpecialty) AND (TerritoryID = DLookup("TerritoryID", "tblMalpracticeLocations", "LocationID = & Forms![frmAssignments]!MPLocation")))
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.