>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.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope