hi guys i am trying to create relationships between two tables in an asp application. one of them is used as the primary key table and the other is used as the FK table. the problem is that the relations go well until i'm trying to save the tables and it tells me that The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Shop_Category". what is that mean? what is the ALTER TABLE STATEMENT? how can it be fixed? thanx me
The Alter Table Statement is SQL that changes the structure of a table, this could include creating relationships. Without seeing your code I believe it is probably a duplicate key problem.
Can u post ur code?? The alter table is for changing a table structure and does n't hv any relationship with wht u r doing here i.e joining... where r u working SQL Server or something else??