Hi, All.  I know it's recommended that you don't have a "circle" of relationships, meaning 3 tables that are all related to each other.  The preferred structur is a "line" of relationships, meaning 1 table is related to the 2nd table, and the 2nd table is related to the 3rd table.  I'm restructuring this mess of a database and wondered if there's any way to avoid a relationship "circle" or if it's OK in some circumstances to have a relationship "circle".  Here's the scenario:

tblSuppliers:  SupplierKey (primary key), SupplierName, SupplierAddress, etc.

tblSupplierContacts:  SupplierContactKey (primary key), SupplierKey (foreign key), ContactName, ContactPhoneNbrs, etc.

tblSupplierOrders:  SupplierOrderKey (primarykey), SupplierKey (foreign key), SupplerContactKey (foreign key), SupplierDetails, etc.

The Supplier Orders has to list both the supplier and the supplier contact.  As a result, I can't figure out how to avoid a "circle" of relationships.

Any advice/suggestions/guidance will be appreciated.  Thanks much - Emma