Oh I wasn't clear. Keep the old field, but don't have it be either autonum nor pk. The new pk could be an autonumber? I'm experimenting here with you because I've never had this happen.
I'm thinking you'd want the old numbering scheme as reference just long enough to determine that the new linking worked.
Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Wednesday, May 16, 2012 10:58 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Auto Number and duplicates
Liz
Why am I making both the old and new fields PK?
Jim Wagner
________________________________
________________________________
From: Liz Ravenwood <liz_ravenwood@beaerospace.com>
To: "'MS_Access_Professionals@yahoogroups.com'" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, May 16, 2012 10:44 AM
Subject: RE: [MS_AccessPros] Auto Number and duplicates
0. BACK UP All Stuff
1. copy structure on to a new table/s structure only
2. amend new table design/s to have an additional pk autonum, and the old autonum to just num
3. append/paste old table to new table/s
4. establish new relationships based on the new pk (but I'd leave the old number's behind for reference)
Look at what you get and see it it links out okay
Best of luck. What a fun little mess.
Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Wednesday, May 16, 2012 10:38 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Auto Number and duplicates
I failed to mention that there is a related table with task details that are linked together
Jim Wagner
________________________________
________________________________
From: luvmymelody <luvmymelody@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, May 16, 2012 10:33 AM
Subject: [MS_AccessPros] Auto Number and duplicates
Hello everyone,
I just discovered that my Auto number has duplicates. So I checked the design and it has Yes(Duplicates OK). First of all my ignorance was that I always thought Auto numbers would be indexed as no dups. So Now how do I renumber these tasks?
Thank You
Jim Wagner
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
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.
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
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.
Tidak ada komentar:
Posting Komentar