Hi, when I try and join the two databases, I get the follwing error message
'Genre' table saved successfully
'Review' table
- Unable to create relationship 'FK_Review_Genre'.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Review_Genre". The conflict occurred in database "C:\BEGASPNET\SITE2\APP_DATA\PLANETWROX.MDF", table "dbo.Genre", column 'Id'.

Any ideas?

Hi there,

Does your Review table already contain records? If so you need to delete them first (or change their GenreId to match with one of the Genre records).

The database enforces the relationship between the two tables, sees that one or more of the records cannot be matched and then stops you from creating the relation.

Hope this helps,

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!

Hi Imar
That was exactly the problem, I've been away from this for weeks and had lost track of what I had done.

Thanks very much