Table Relationships

[PATRICKPBME]

Am I correct that in order to have a relationship between tables, the tables must have at least one field in common?

[CJ_London]

err yes - usually the primary key of one table and the family (or foreign) key in the other. You would not have a relationship between two fields in one table and one field in another

[PATRICKPBME]

Thanks. I believe my initial error was designating the similar field in both tables as the primary key.