>Hi,
> I have two tables, supplier and product. That is many to many relation between thiese two tables becoz one supplier may sipply more than one product. And on the other hand, same product may be able to suppy by many supplier.
> How should I set the relation?
> I got cycle relation error!!
>
>Thank you

For many to many relationships you need 3 tables.

Supplier
Product
SupplierProductLink

Say your Supplier Table looks like:

SupplierKey
SupplierName
SupplierAddress

Say your Product Table looks like:

ProductKey
ProductName
ProductDescription

Then the SupplierProductLink linking table would be:

SupplierKey
ProductKey


Thus the link table would hold the many to many relation.

Hope this helps.