I have a form with 4 checkboxes. Each check box represents the number of records that needs to be added to a table with the same patient id. For example:

patient id 333-3332-33331

The user receive a registration form and an annual form. So therefore they check those two boxes.

Now when the user wants to add the records and presses submit forms button, I want it to appen to the table two different records.
Field struc: id,c(12), typeofform, c(20)....

So once they submit the forms, the table will contain two records but the only difference will be the typeofform field containing...
REGISTRATION in one record
ANNUAL in the other record

Any ideas?

TIA

Jeff T.