many to many relationship

Jan 24, 2012 at 10:27 AM

How to use slam to achieve many to many relationship between SharePoint 2010 lists.

Developer
Jan 24, 2012 at 1:59 PM

Without creating a custom field type, you can simply place a look up field on one list pointing to the other and configure it to allow multiple values.  Slam that list and you can save the relationship in a "association table". Now this will only allow you to manage the relationship on one list.

If you want a control on both lists, you can accomplish this by creating a custom field type and storing the relationship in SQL instead of sharepoint.

Hope that helps!

Allan