Hi Kurt. Thanks that was it. I removed the orphans and it works fine now.
>You probably have a detail record that doesn't have a corresponding record in the header table. You will have to find the orphan record and fix it before SQL server will allow you to create the constraint.
>
>Try the following SELECT statement to identify the orphan so you can fix it accordingly:
>
>SELECT *
> FROM clinsdet t0
> LEFT JOIN clinserv t1
> ON t0.id = t1.id
> WHERE t1.id IS NULL
>
>
>Kurt
>>In the database diagram tool, I am attempting to creat a relationship betwen two tables. When I look at the constraints for both tables, I there are none listed. Clinserv is the parent table with a 1 to many relationship with the child table clinsdet. Clinsdet.fk_clinserv is a field with an index on it (IE the foreign key). I want to relat this to clinserv.id which is a primary key. I can drap clinsdet.fk_clinserv and drop it onto clinserv.id. When I save the diagram I get the following error.
>>
>>
>>'clinserv' table saved successfully
>>'clinsdet' table
>>- Unable to create relationship 'FK_clinsdet_clinserv'.
>>The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_clinsdet_clinserv". The conflict occurred in database "ecpvgh", table "dbo.clinserv", column 'id'.
>>