I have the situation where my database design includes a number of many-to-many relationships. As an example, if one looks at the AdventureWorks database (included in MSSQL 2005) you will see VendorAddress linking Vendor and Address. Note also that the link table includes additional data! Vendor is also linked to Contact via VendorContact. If you look at Customer and Employee you will note similar linkages.

I am wondering if anyone has implemented - using MM.Net biz objects and stored procedures - a UI to present this info and handle user modifications. There is an example in the MM.Net documentation (ver 2.4) that utilizes the Mover control to deal with the User/Roles/Security many-to-many tables. It also employes dynamic SQL and datasets, both of which I cannot use. Also Mover control does not apply to my presentation which lends itself more to a grid. Consider a Vendor as being the 'parent' to the 'semi-children' of Addresses and Contacts - 'semi' due to the intervening link table.

Currently that is my endeavor: a grid containing the combined info from both the Address table and the VendorAddress link table, with the Vendor having been chosen 'parentally'. The only pure biz object solution I can come up with is to use a database View to incorporate the info into a biz object so that it can be easily bound to a grid (BTW I'm using Infragistics). I will need to write the back-end handling of modifications being sent back to the DB.

Any help anyone ???