Hello UA!...

I am setting up an Owner Proposal form, and am looking into copying an existing record into a new record for the purpose of revisions. How would I do this? An append query? How would I do that? Here is what I am doing though (in case you have a better idea)!

My Owner Proposals are numbered like so:
P-1392-1
P-1393-1
P-1394-1

My thinking on the copy and paste idea is for possible future revisions (a change that might need to be made) that any one of these numbers might receive. I need to keep the info from the unrevised record, but would likley use a lot of the same information. An example of a revised number I would use:

P-1394-1 (above) revised = P-1394-1-R1

...if another revision needed to be made, it would then read P-1394-1-R2 and so on.

Please, if you think you may have another alternative to my idea, I am open to anything! Thank you so much for your time!

Revisions should be data in a related table....

tblOwnerProposal
OwnerProposalID (PK and auto)
ProposalNumber
...other fiields...

tblRevisions
RevisionID (PK and auto)
OwnerProposalID (FK)
RevisionNumber
RevisionDate
Description

Something along those likes as you can get the latest revision, from the table, for any proposal very easily...

hth,
Jack

Nice! Thanks for a steer in the right direction!

You are welcome and good luck with the project...

Jack