Is there a way in SP2010 to represent a N:M relation?
I mean: i have two lists: "projects" and "collaborators"
The "projects" list contains a lookup field named "collaborator", which lists all the collaborators working on that project
On the other side, in the "collaborators" list, i have a "porojects" lookup field which lists all the project the collaborator is currently working on
If i modify one of the two lists (for example adding a collaborator in the "collaborators" field of the "projects" list) i need that the change reflects itself on the other list too (adding a project in the "projects" field of the "collaborators" list).
Is there a way to do this in SP2010 or do i need to write complex and long event-handling code?
View Complete Post