Creating Relationship between tables in SQL Server 2000
I have created a database which has the following tables:
Customers, Orders, Products, Categories, OrderDetails, ShoppingCart.
I have created the individual tables and set the column name (eg: orderID, orderName...) and the datasypes for them.
How do I create the relationship between the tables with SQL Server 2000?
I searched in google but didnt find any good tutorial.
I think you have to first create the relationship otherwise the tables wont be updated automatically is it? For example if I update a OrderDetails table then the Orders table should update automatically etc.