I'm trying to create a relationship between two tables using the SQL Server Enterprise Manager. To do this, I followed the documentation; expanded my database --> Diagrams -right click-> New Database Diagram --> and I followed the wizard. When I finished, I had a white space area with nothing on it(despite I think there should be the two tables I chose to include in the diagram - nevertheless), and when I clicked on the add table icon but the following message appeared:
"CoInitialize has not been called"! Do anybody of you know anything at all about what this message is talking about?
Is it possible to have two foreign keys in the same table pointing to a primary key in another table? For example, I have table called USERS, and another called ADDRESSES, the ADDRESSES table can be explained as billing or shipping addresses, so the USERS table may have shippingid and billingid fields pointing to addressid field in the ADDRESSES table.
This may look very primitive, but I really need an answer. What do we need the primary key - foreign key relationship for? Can't we just retieve the records from tables without this relation?