Circular Loop

[sn_9052]

Hi All,

I am having query in circular loop.

Below i attached a file, In that there is a circular loop.

Could any one help me out, how to avoid that issue.

I need relation between  Products and suppliers also,I don't want to break them.

Thank You.

[m_woolf]

Not sure what your link table is for. If it contains address info for both suppliers and customers, split it into two tables: Supplier Address and Customer Address. Or maybe better, put the supplier address info in the Supplier table and the Customer address info in the Customer table. Just make sure the names don't link. Supplier.Name and Customer.Name...