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:
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!