My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Copy and paste a record
|
|
 Oct 2 2006, 03:37 PM
Post
#1
|
|
|
UtterAccess Guru Posts: 518 From: Rivendell, Middle Earth  |
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! |
 |
 
|
|
Oct 2 2006, 04:01 PM
Post
#2
|
|
|
Retired Moderator Posts: 37,716 From: The San Francisco Bay Area |
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 |
|
|
|
|
Oct 2 2006, 04:54 PM
Post
#3
|
|
|
UtterAccess Guru Posts: 518 From: Rivendell, Middle Earth |
Nice! Thanks for a steer in the right direction! (IMG:http://www.utteraccess.com/forum/style_emoticons/default/yayhandclap.gif)
|
|
|
|
|
Oct 2 2006, 04:58 PM
Post
#4
|
|
|
Retired Moderator Posts: 37,716 From: The San Francisco Bay Area |
You are welcome and good luck with the project...
Jack |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 20th June 2013 - 01:11 AM |