By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,596 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Desperate! Please Help!!

P: n/a
KT
I realized the creator of the database I am working on used a text
field to link the main table with another table. I am trying to clean
up this table and set up an autonumber field to use as a primary key.
Is it possible for Access to look at the text field and automatically
set a numeric primary key to the record? (I have already clean up all
alphanumeric data in the text field, now it contains only numeric
data)

Sound quite impossible to me....any suggestions will be appreciated.
I am just desperate..
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ka****@rocketmail.com (KT) wrote in message news:<fe************************@posting.google.co m>...
I realized the creator of the database I am working on used a text
field to link the main table with another table. I am trying to clean
up this table and set up an autonumber field to use as a primary key.
Is it possible for Access to look at the text field and automatically
set a numeric primary key to the record? (I have already clean up all
alphanumeric data in the text field, now it contains only numeric
data)

Sound quite impossible to me....any suggestions will be appreciated.
I am just desperate..


No. You can create a temporary table of the unique values and then
write the numeric PK to the table if you want. Then relink on that.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.