INSERT INTO #Request.prefix_db_agency#.Event ( EventSub_ID, Patient_ID, Event_Date, Memo, Resolved, Agency_ID, who_observed, MD_notified, Was_observed, injury, Followup_desc, Followup_memo, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( '#Trim(form.EventSub_ID)#', '#Trim(form.Patient_ID)#', #CreateODBCDate(form.Event_Date)#, '#Trim(form.Memo)#', '#Trim(form.Resolved)#', #session.AgencyID#, '#Trim(form.who_observed)#', '#Trim(form.MD_notified)#', '#Trim(form.Was_observed)#', '#Trim(form.injury)#', '#Trim(form.Followup_desc)#', '#Trim(form.Followup_memo)#', #CreateODBCDate(Now())#, #Session.EmployeeID#, #CreateODBCDate(Now())#, #Session.EmployeeID# ) Select LAST_INSERT_ID() AS id INSERT INTO #Request.prefix_db_agency#.Event_to ( Event_id, Emp_ID ) VALUES ( '#id#', '#a[i]#' ) UPDATE #Request.prefix_db_agency#.Event SET EventSub_ID = '#Trim(form.EventSub_ID)#', Patient_ID = '#Trim(form.Patient_ID)#', Event_Date = #CreateODBCDate(form.Event_Date)#, Memo = '#Trim(form.Memo)#', Resolved = '#form.Resolved#', who_observed = '#form.who_observed#', MD_notified = '#form.MD_notified#', Was_observed = '#form.Was_observed#', injury = '#form.injury#', Followup_desc = '#Trim(form.Followup_desc)#', Followup_memo = '#Trim(form.Followup_memo)#', Record_Mod_Date = #CreateODBCDate(Now())#, Record_Mod_By = #Session.EmployeeID# WHERE Event_ID = #form.Event_ID# DELETE FROM #Request.prefix_db_agency#.Event_to WHERE Event_ID = '#form.Event_ID#' AND Emp_ID NOT IN (#form.employee_id#) SELECT id FROM #Request.prefix_db_agency#.Event_to WHERE Event_ID = '#form.Event_ID#' AND Emp_ID = '#a[i]#' INSERT INTO #Request.prefix_db_agency#.Event_to ( Event_ID, Emp_ID ) VALUES ( '#form.Event_ID#', '#a[i]#' ) Unable to Create/Update Event: Form Data is Missing