delete
from dOrgToService
Where OrgID = #URL.ORGID#
Insert Into dOrgtoService (OrgID, ServiceID)
Values(#URL.OrgID#, #Array[x]#)
Insert into dService(Service,Type, Approved,CenterID)
Values('#form.Other1#','Expertise',1,7)
Select Max(serviceid) as maxSid from dService
Insert into dOrgtoService (OrgID, ServiceID)
Values(#URL.OrgID#, #getMaxServiceid.maxSid#)
Insert into dService(Service,Type, Approved,CenterID)
Values('#form.Other2#','Resources',1,7)
Select Max(serviceid) as maxSid from dService
Insert into dOrgtoService (OrgID, ServiceID)
Values(#URL.OrgID#, #getMaxServiceid.maxSid#)
Insert into dService(Service,Type, Approved,CenterID)
Values('#form.Other3#','Clients',1,7)
Select Max(serviceid) as maxSid from dService
Insert into dOrgtoService (OrgID, ServiceID)
Values(#URL.OrgID#, #getMaxServiceid.maxSid#)