Where can I get some good information on how to build relationships in SQL Server 2005? I have a main table with names in it. The second table has properties of these unique names from the first table. these properties are dynamic and can take up multiple rows for one unique name. I want to link them, and if possible, be able to query the unique name in Table_1 and be able to get the results of that unique name from Table_2.

I hate my secrecy agreement sometimes, makes it difficult to explain what I am doing....