Setting Unique Identifier Key of One Table to Foreign Key of Another 1

[BoulderBum]

If I have a field in one table that is a uniqueidentifier, how do I set up the field in a second table to have a one-to-many relationship to that uniqueidentifier?

Also, I have a small number of records, is there a better way to handle unique identification that would be automatic? The uniqueindentifier is 16 bytes large from what I understand, and an auto-incremented short would do, I just don't know how to set that up with SQL Server.

 

[Transcend]

You could set the identity field to type int, in design view select

identity yes
identity seed 1
identity increment 1

This will give you an automatically populating integer key field.

Then to set up the foreign key relationship make sure that the corresponding field in the second table is the same data type. In design view of your table click the relationships button which shoudl be third in from the right ... and you can create the foreign key in there.

Transcend

 

[BoulderBum]

Thanks!