I have a database that stores job competitions and applicants. I have a table called Applicants. It has a primary key named AppID, a field called CompetitionID and other fields storing name, address etc. Applicants for job competitions have an AppID and a CompetitionID. Users would like to enter an existing AppID and insert a new record with the existing information duplicated but with a new CompetitionID.I need a query that can create a new record consisting of a copy of an existing record specified by the AppID the user enters in the Parameter, with the new record having a new sequential CompetitionID. Any ideas?
Query to duplicate a record with one field updated
- Thread starter reef21
- Start date