Take a look at INSERT - SQL. It's a little neater than APPEND BLANK and REPLACE when you are trying to deal with one at a time record appending as you are here. You can specify which fields to populate in the new records and what values to populate those fields with.
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only