This relationship related question has two potential answers. The first answer (and the one that you want to hear) is the use of foreign key constrain ...
Search results for foreign key
A primary key is the field(s) in a table that uniquely defines the row in the table; the values in the primary key are always unique. A foreign key is ...
What are the constraints ?
Posted by Devin
Table Constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity. SQL Server 2000 support ...
« previous1 next »