Thedon123
Registered User.
- Local time
- Today, 21:57
- Joined
- Sep 11, 2002
- Messages
- 98
I have been asked to update this database with new records. the problem is i have been given records that have two sof the same values for the prinmary key.
Som i decided to remove the primary key. this meant removing the relationship all ok.
But when i tried to put the relationship back agin it would not enforce referential integrity. It vchanged from a one-to-many to an inderminate relationship. I want to enforce referential integrity so i put the primary key back obviously having to get rid of the duplicate record values.
Is there a way i can get around the inderminate problem above?
Som i decided to remove the primary key. this meant removing the relationship all ok.
But when i tried to put the relationship back agin it would not enforce referential integrity. It vchanged from a one-to-many to an inderminate relationship. I want to enforce referential integrity so i put the primary key back obviously having to get rid of the duplicate record values.
Is there a way i can get around the inderminate problem above?