Feb 18 2004, 03:43 PM
I have a main data table with an autonum field as the PK. I have since built a good sized DB off of this table, and now might have to change the PK to a different data field (ACK!).
Is there any easy way to do this so that I don't have to update every query, table, report, form that refers to the key in this table?
If there isn't, I will leave it alone, but if there is a trick, I would love to hear it!
Feb 18 2004, 03:45 PM
Why would you want to change it from an Autonumber field?
What type of field are you trying to put it as?
Feb 18 2004, 04:18 PM
Here are the two fields:
id (autonum, current PK): 1
Someone was working with me on a portion of the DB, and suggested it. He said that if I used Task-id instead of the autonum field, I would be sure that no task_ids were duplicated, as they are imported from an external database.
Do you think it even maters? Do you think how I have it now is a 'bad' database design?
Feb 18 2004, 04:30 PM
No Don't change the PK from the autonumber field! You did it right the first time.
You can add an index to the Task-ID field to prevent duplicates.
Feb 18 2004, 04:38 PM
Aw, right! Thanks, GroverParkGeorge! I will add an index.
By the way, what is PMFJI?
Feb 18 2004, 04:40 PM
"pardon me for jumping in."
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here