How do I define one-to-one relationships in SQLServer 7?

[Guest_imported]

I have not yet realised how to define if the relation should be a one-to-one relationship or one-to-many relationship etc.<br>I've just made the relations of the tables that we are using in our database but they are all by default now set as one-to-many relations. I wonder how I can make a few of them one-to-one relations as that is how the original database is set up.<br>(I am working with a project of converting an existing Access97 Database into SQL Server 7 format).<br>Thanks a lot for you help!<br>-Jonas J

 

[foxdev]

Let's see if I can explain this without screwing up:<br><br>A one-to-one relationship (Table1-Table2) would be one where Table1's foreign key does not allow null values, and refers to Table2's primary key. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>