INSERT INTO #Request.prefix_db_lookup#.Medications ( med_trade_ID, med_tname, generic_name, trade_an_generic_name, Contraindictions, Side_effects, Administration, Assessment, Teach, Outcomes, Interactions, Infectious, Uses, Active, Special_Concerns, Agency_ID ) VALUES ( 0, '#Trim(form.medtrade)#', '#var.genname#', '#var.tradegen#', '#trim(form.Contraindictions)#', '#trim(form.Side_effects)#', '#trim(form.Administration)#', '#trim(form.Assessment)#', '#trim(form.Teach)#', '#trim(form.Outcomes)#', '#trim(form.Interactions)#', '#trim(form.Infectious)#', '#trim(form.Uses)#', 1, '#trim(form.Special_Concerns)#', #session.AgencyID# ) SELECT Trade_an_generic_name AS MedName, medications_ID FROM #Request.prefix_db_lookup#.Medications ORDER BY Trade_an_generic_name SELECT DISTINCT generic_name AS GenName FROM #Request.prefix_db_lookup#.Medications ORDER BY generic_name Medications

Medication Form - New

Current Medications:

Back to Medications Menu

#getM.MedName#