I have created a simple info path (2010) form and connected it to the Access Database with access key as ID number (auto number). I am able to use the Run Query option to retrieve a form and resubmit it after making any changes (overwrites the previous data).
My Question. After I retirve a previously submitted form and make changes I want to submitt it as a new entry into the database.
Currently it just overwrites previous data in the data base.