Also, when they just click new, it picks an unused number that isn’t the last and highest. This seems reasonable to me considering all the data I had to delete.
I need to maintain the existing autonumber generated value, so I don’t want to resquence them.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Wednesday, February 12, 2014 9:04 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] autonum with missing values
Pros, I messed up a database and had to delete a bunch of data. I have an autonumber field and a procedure that allows someone to duplicate a record.
When they duplicate a record it isn’t taking the highest of the high, but a number in the middle. Is this normal behavior?
Arrgh…
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar