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:

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'.

Hi there,

Is this related to my book? If so, can you sepcify the chapter and page number you're working on? If it's not, please post messages like these in an appropriate general forum such as one of the SQL Server, Visual Studio or ASP.NET forums.

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

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!