I have records in my database and when viewing a record, I wanted to be able to have a button that would create a new record (new ID number) with the same data that was in the record I chose to create a new one off of. So a user wouldn't have to re-type all of the data in if they would like to change one thing.
So essentially I want to be able to clone a item into a new record.
Any help would be appreciated