You can right-click any table in the Relationships window and then choose Table Design from the shortcut menu to open that table in Design view. You can also choose Print Relationships (Access 2000) from the File menu while viewing the Relationships window to create a report that prints what you have laid out in the window.
Relational databases support a special value in fields, called a Null, that indicates an unknown value. Nulls have special properties. A Null value cannot be equal to any other value, not even to another Null. This means you cannot join (link) two tables on Null values. Also, the test “A = B,” when A, B, or both A and B… Read more »