What are some options for creating a many-to-many
relationship between two web parts? For example, I have
a client list and a contact list. A client can have
multiple contacts and vice versa.

Typically, I would use an intermediate table with foreign
keys to both the client and contact tables. I've had
some limited success with setting up the lists, but can't
seem to get the behavior that I need (which is: when I
display client in one web part the associated contacts
show up in another connected web part ... but using an
intermediate table as part of the equation). Here's my
many-to-many relationships:

client -> intermediate_table <- contacts


After setting up the three lists in my test case, I put
three web parts on a page and tried to set connections
appropriately, but got a message saying that the number
of inbound connections (to my intermediate list) was
exceeded because I had already set the other connection.


If I'm thinking about this in the wrong way, and there's
a better approach ... I'm open.

Thanks in advance.

Dave.

Hi, David

I assume your web parts are in the context of a sharepoint server.

Are you using SPS 2001 or 2003?

What is your backend database?

Are the connections you are referring to between your web parts, or to the
database?

I assume these are custom Web Parts. What programming language are they
written in?

Please get back to me with more information and I will see what I can do to
help.

Thank you for choosing the MSDN Managed Newsgroups,

John Eikanger
Microsoft Developer Support

This posting is provided “AS IS” with no warranties, and confers no rights.
(c) 2003 Microsoft Corporation. All rights reserved.
--------------------
| Content-Class: urn:content-classes:message
| From: "David Remillard" <dar>
| Sender: "David Remillard" <dar>
| Subject: Many-To-Many Web Part Connections?
| Date: Tue, 2 Sep 2003 09:42:06 -0700
| Lines: 31
| X-Tomcat-NG: microsoft.public.vsnet.general
|
| What are some options for creating a many-to-many
| relationship between two web parts? For example, I have
| a client list and a contact list. A client can have
| multiple contacts and vice versa.
|
| Typically, I would use an intermediate table with foreign
| keys to both the client and contact tables. I've had
| some limited success with setting up the lists, but can't
| seem to get the behavior that I need (which is: when I
| display client in one web part the associated contacts
| show up in another connected web part ... but using an
| intermediate table as part of the equation). Here's my
| many-to-many relationships:
|
| client -> intermediate_table <- contacts
|
|
| After setting up the three lists in my test case, I put
| three web parts on a page and tried to set connections
| appropriately, but got a message saying that the number
| of inbound connections (to my intermediate list) was
| exceeded because I had already set the other connection.
|
|
| If I'm thinking about this in the wrong way, and there's
| a better approach ... I'm open.
|
| Thanks in advance.
|
| Dave.
|
|