Hi Tom, you can use dbio=False in the accepts and do the insert "manually" as explained in http://web2py.com/book/default/chapter/07#SQLFORM-without-database-IO
On Dec 3, 7:12 pm, tomt <tom_tren...@yahoo.com> wrote: > Hi, > > I've started to write a simple application to learn web2py. I am using > SQLFORM to insert, modify and delete records. So far everything is > working as planned. > > I would like to give the user the ability add a new record as a copy > of an existing one. The idea is that the user would view an existing > record, modify a couple fields, and select 'copy' which result in > adding a new record. > > I assume that this requires additional code, and I was hoping that > someone would suggest an example, or let me know if SQLFORM can do > this automatically. > > Thanks in advance, > > - Tom