I am working on the bacterial projects regarding collecting data to study the prevalence of antibiotic resistance.
The step in susceptibility process, I have to select drugs in subform (stSusceptibility Subform) based on a pathogen (Result) in main form (stSusceptibility Details Form),
Is it possible to create only one button for 8 criteria and automatically interpret to S,I or R in Interpret field when input data in Zone Diameter field based on reference range (S_ZD, I_ZD, R_ZD fields)
For example
if a pathogen in main form is Aeromonas caviae which is in Aeromonas group (GroupDrug field in stBacteriaGroups table) then select DrugID; AAZMR18, ACAZ10, ACIP10, ACRO10, ACTX10, ANAR18, ASXT10 and ATE10 in Antimicrobials table.
if a pathogen is Campylobacter coli in Campylobacter coli group >> select CAZMCC13, CCDCC13, CECC13, CTECC13, CC13, CCIP13, CCN13, CNA13 >>Campylobacter will input data in MIC field and interpretation depends on S_MIC, I_MIC, R_MIC
MIC and Zone Diameter are the value from performing susceptibility testing but different methods
Campylobacter and Arcobacter >> MIC, other pathogens >> Zone Diameter
Attachment 38178
Attachment 38179
Attachment 38180
Attachment 38181
I have been trying to search for this for a couple days but I cannot find the answer.
Thank you very much in advance.