Update #Request.prefix_db_agency#.Invoices, #Request.prefix_db_agency#.pSchedules Set Invoices.Deleted = 1 Where Invoices.Invoice_ID = pSchedules.Invoice_ID and pSchedules.Schedule_ID in (#form.items#) Update #Request.prefix_db_agency#.pSchedules Set Date_Change = #now()#, Change_by = #Session.EmployeeID#, Eclaimed = 0, Invoice_ID = 0, Export_Date = NULL Where Schedule_ID in (#form.items#) AND status = 0