advanced checkbox logic

[rwh]

OK need some advanced logic with checkboxes below is the general outline and how it needs to work.

example code segment:

<form XXXXXXXXXX>

form # 222
several input standard stuff>

<input xxxxxx>
<input yyyyyy>
Now here is where the hard part enters into play.

place a checkbox on this form screen and if the box is not checked just do a standard submit to the database.
but if the checkbox has a value of "1" we need to keep all the data on the standard form and populate the database and then open up a new form with the standard data showing and the form number now would look like this
new_form # 222-1  allowing for addational data to be entered.

so simple terms

1 If the box is Not checked just process the form inputs and form number to the database.

2. If the box is checked than keep the form number and add a dash with a new number for the sub form i.e 222-1

3. process the new sub-form to the sub-form database with the addational added number.

so lets see what falls out of the coding tree on this one

tks..