What I am trying to do is check to see if there are any matches in rs_IncCheck and if the row result =0 then do the insert based on the content of the form with repeat region which is populated by rs_DesignTypeDBAdd all of which is hidden.
The page will then include an update form based on the content just inserted. But if the content is already in the des_res_type table it will ignore the insert form and just go straight to the update form.
I am doing it this way around so when the site admin add a new product and select an option button, all the options will already be listed there and each will just require a tick box to select if that option will be included with item, I can do all this section fine but I need the multiple insert to add the content to start the whole process off, there are options in the multi insert for "before page loads2 and "if record set is empty" is the page layout in the incorrect sequence?