Background: I'm creating a clinical decision support tool in which a Query will provide doctors with a suggested decision for a patient's prescribed drug based on whether the patient's medical condition falls under the domain of the drug. I.e., if a patient is taking an anti-depressant and any of their diagnoses are Depression, then the output query will say "Approve" in the Suggestion column. This query is finalized and the IIF statement works. However, it utilizes a LEFT JOIN, so the provider cannot edit the final field in the query "Provider Decision" to denote their official decision to approve or deny the med.
Therefore, I'm trying to create another query and use a Dlookup to pull in the Suggestion field from the first query so the provider can edit the record. However, the Dlookup I'm using below is taking forever to run and ends up freezing the program. There's only ~530 entries for the Dlookup to search.
Suggested Decision: =Dlookup("[Suggestion]", "Query1", "[AUTH NBR]='" & [AUTH NBR] & "'")
Therefore, I'm trying to create another query and use a Dlookup to pull in the Suggestion field from the first query so the provider can edit the record. However, the Dlookup I'm using below is taking forever to run and ends up freezing the program. There's only ~530 entries for the Dlookup to search.
Suggested Decision: =Dlookup("[Suggestion]", "Query1", "[AUTH NBR]='" & [AUTH NBR] & "'")