I am new to SQL Server, and using the Express edition. I can't seem to find
the way to create relationships between tables. Any reference info will be
appreciated.

You can look up ALTER TABLE in BooksOnLine for the full details but the
syntax is nothing special. Here is a sample from BOL:

ALTER TABLE Person.ContactBackup
ADD CONSTRAINT FK_ContactBacup_Contact FOREIGN KEY (ContactID)
REFERENCES Person.Contact (ContactID) ;

If you are talking about a graphical way I am not sure what the express
version of Management Studio supports but the table designer has a section
for Foreign Keys.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Do you have any tools like Visual Studio? Try creating a Database Diagram.
This has a tool to build relationships using a GUI interface. This is
described in detail in my book.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]