Hi,
I'm relatively new with ADO .NET and am having some trouble setting up my tablets and relationships in ado, can't find find much info out there on many-to-many relationships.
I'm using the MySQL Connector/.NET to access my DB and have set up a connection, it's just an implementation of the .net DB objects, so it has all datatadapter objects etc etc.
My tables are as follows, suppliers_brands linking the two tables, ie. a supplier can have many brands, a brand can have many suppliers.
supplier
-------
supplier_id
supplier_name
suppliers_brands
----------------
supplier_id
brand_id
brand
-----------
brand_id
brand_name
I've been able to fill a dataset with the 3 tables; my question is how do do I define the relationships (in code) so that I can select all the brands (the actual brand names) associated with a given supplier_id or vice versa (suppliers associated with a brand_id).
Thanks for any tips :)
