Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Old 04-09-2008, 06:08 PM Forms / Subforms
Junior Talker

Posts: 4
Name: andrew
Trades: 0
What does it mean when you get this error message?

"the changes you requested have not been successful because they would create duplicate values in the primary key or relationship"

and what can you do to resolve it?

can anyone help please?
andrewc266266 is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 04-09-2008, 06:14 PM Re: Forms / Subforms
VirtuosiMedia's Avatar
Web Design Made Simple

Posts: 1,228
Trades: 0
Without more information, it's difficult to know what you're doing wrong. From your error message, I'd guess that you are trying to create identical values for a column that is marked as the primary key. Primary keys must be unique.
VirtuosiMedia is offline
Reply With Quote
View Public Profile Visit VirtuosiMedia's homepage!
 
Old 04-09-2008, 07:02 PM Re: Forms / Subforms
Junior Talker

Posts: 4
Name: andrew
Trades: 0
I have a form with a linked subform and when i try to add to the subform that error message appears
andrewc266266 is offline
Reply With Quote
View Public Profile
 
Old 04-10-2008, 02:01 PM Re: Forms / Subforms
Learning Newbie's Avatar
Defies a Status

Latest Blog Post:
Astounding Republican Paranoia
Posts: 5,662
Name: John Alexander
Trades: 0
The error means exactly what it says. You have some column or group of columns that you've defined as unique. So you can't put dupes into them. And you're trying to. How you would fix it is to filter out the duplicates from your insert or update statement that's throwing the error.
__________________

Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE
Learning Newbie is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Forms / Subforms
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.70564 seconds with 12 queries