I currently have a repeated region that print the information stored in a database with check boxes next to the info.
What I want to do is:
When someone checks the box and presses the submit button, I would like for the information to be stored in a new database with new id numbers. The user will be able to select multiple entries at a time so I am not sure how this works.

Would I need to setup a new database with all the exact same columns as the table I am transferring from?
I know I need a loop but what would the database command look like because I think I would need to do a select all where id = id and insert into table....

Any help would be greatly appreciated.