Rabu, 16 Mei 2012

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]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar