>>>>>Is there a GUI tool for creating referential integrity between tables in SQL 2005? Or do need to do this via the ALTER TABLE command?
>>>>Do you have SQL Server Management Studio? (it can be downloaded for free)
>>>>I am pretty sure you can set up referential integrity between tables with that.
>>>>If you have VS2005 pro you can also set up referential integrity in the server explorer.
>>>
>>>I must be blind, which particular part of those tools are you referring to?
>>
>>In the server explorer you can use the database diagrams section. Add the tables to the diagram and then drage constraints between PK and FK. I don't have the management studio installed on this machine yet, but I am sure it is similar.
>>
>>Einar
>
>Thanks Einar, I thought that was just creating a diagram, I didn't know it was actually writing changes back to the database.

I thought the same thing when I started using it.

>
>I must being doing something wrong here, are the relationship lines supposed to point directly to each of the fields in the tables, or do they just show the tables linked?

The lines just show that the tables are linked. If you right-click on the line and select properties then you can see exactly what fields are linked.