>Hi -
>I am trying to move some VFP data into SqlServer 2008 and establish a delete cascade between 2 tables. The import has been done but I am having trouble creating the relationship. Both tables have secondary unique indexes on fields with the same name (not the primary key). As far as I can tell, all the records in table 2 have a match in table 1. I can create the relationship in the diagram but when I attempt to save it I get an error that says :
>
>'Projects' table saved successfully
>'RTA-GeneralInfo' table
>- Unable to create relationship 'FK_RTA-GeneralInfo_Projects'.
>The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_RTA-GeneralInfo_Projects". The conflict occurred in database "TIP", table "dbo.Projects", column 'TipID'.
>
>TipID is the common field, Projects is the parent table, and RTA-GeneralInfo is the child table. Can someone suggest what I may be missing?
>Thanks
Do you have orphans? Verify there are no orphans first.
If it's not broken, fix it until it is.
My Blog