Evan,

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'.
>