I still cannot define a one-to-one relationship in SQL Server 7

[Guest_imported]

I have checked, according to Robert Bradley's tip, that Table1's foreign key does not allow null values, and refers to Table2's primary key. Still SQL Server 7 sets my join-type to a one-to-many relationship.<br>The two fields that I am trying to relate are of the type nvarchar.<br>In Access97 this join type is a one-to-one relation.<br>I really appreciate any help you can give me to solve this problem.<br>-Jonas

 

[calahans]

Set a unique constraint on both columns. If either of the columns are a primary key, then that is enough for that column. What I would do next is the create a unique index on the second column. This should enforce a one to one relationship between the tables <p>Cal<br><a href=mailto: > </a><br><a href= > </a><br>

 

[Guest_imported]

Thanks Cal!<br><br>I have now managed to make a one-to-one relationship How great!<br><br>As one of my columns is a primarykey, I only created an index for the seond column and then it automaticially changed to a 1-to-1 relationship.<br><br>