>>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
>
>Hi all again -
>Please disregard this request. I found some more unmatched records and clearing them out took care of the problem. Sorry.

No need to apologize, Don. There have been questions here in the past few days from Tamar, Rick, and Naomi, people you generally only see answers from. That's why the UT is here. I'm glad you figured it out.