SELECT Supply_ID, Price, HCPCS, Revenue_Code FROM #Request.prefix_db_agency#.Supply WHERE Supply_ID = '#form.Supply_ID#' AND Agency_ID = #session.AgencyID# INSERT INTO #Request.prefix_db_lookup#.Supply_Sched ( Supply_ID, ScheduleItems_ID, Patient_ID, Assessment_Tracker_ID, Total_Units, Total_Price, Revenue_Code, HCPCS, Payer_ID ) VALUES ( '#form.Supply_ID#', #form.ScheduleItems_ID#, #form.Patient_ID#, #form.Assessment_Tracker_ID#, #form.Total_Units#, #Total_Price#, '#Rev#', '#HCPCS#', #form.Payer_ID# ) UPDATE #Request.prefix_db_lookup#.Supply_Sched SET Total_Units = #form.Total_Units#, Total_Price = #Total_Price#, Revenue_Code = '#Rev#', HCPCS = '#HCPCS#' WHERE Supply_Sched_ID = #form.Supply_Sched_ID#