Error I don't understand!!

Rabruba · April 2nd, 2011, 06:56 AM

Hi everybody,
Please help me with this error...
I'm making the relationships between database tables, and there is a relation between a table i created "UserDetails" and the "aspnet_Membership" table where the UserID in (UserDetails) is a primary key and it's a foreign key in (asp_Membership).
But when I want to save this I get this error:

/*
Saturday, April 02, 20111:48:23 PM
User:
Server: .
Database:
Application:
*/

'UserTypes' table saved successfully
'UserDetails' table saved successfully
'aspnet_Membership' table
- Unable to create relationship 'FK_aspnet_Membership_UserDetails'.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_aspnet_Membership_UserDetails". The conflict occurred in database "C:\USERS\RUBA\DOCUMENTS\VISUAL STUDIO 2010\PROJECTS\PROJECT1\FIRST\SITE\APP_DATA\ASPNETD B.MDF", table "dbo.UserDetails", column 'UserID'.

Imar · April 2nd, 2011, 07:13 AM

Heuh? Aren't we discussing this here already: Error I don't understand

And what about:

Quote:

That said, on which column in the membership table are you joining? Maybe it has already some constraints set?

Cheers,

Imar

Rabruba · April 2nd, 2011, 08:29 AM

Quote:

Originally Posted by Imar

Heuh? Aren't we discussing this here already: Error I don't understand

And what about:

Cheers,

Imar

I know, but you told me to discuss it at another forum

Rabruba · April 2nd, 2011, 08:30 AM

I join to UserId column

Imar · April 3rd, 2011, 08:09 AM

Quote:

I know, but you told me to discuss it at another forum

Yes, I know. But you just copied and pasted the question without answering the questions I was asking. So I didn't see any value in the new post.

That said, it looks like you're relating on the Primary key of the membership table. You can't make this column the primary key, an identity and a foreign key at the same time.

Why not do it the other way around (which is what you want anyway): e.g make aspnet_Membership.UserId the primary key and add it as a foreign key in your own table?

Cheers,

Imar