Last edited Oct 2, 2009 at 7:28 PM by ckeyser, version 2


PlanetParker Sep 14, 2009 at 7:21 PM 
@ziyad6: I didn't capture the same thought from this, as I read it that regular or simple relations between entities can be handled by lists just fine, just not the more complex relationships. Now, that leaves us to define "simple vs. complex" on our own, which could be troublesome. The problem I've noticed when trying to develop sharepoint solutions using lists is that regardless of the simplicity of your list relationships, you have to manage the normalization yourself to a certain extent, or forego it altogether. For example, sharepoint provides no OOB method to allow the user to select a text value in a drop-down list, yet store the related "ID" behind the scenes instead of the full descriptive text selected. You can do this using your own controls, obviously, but then you'd have to manage the updating of that data to the list on your own.

ziyad6 Sep 6, 2009 at 11:49 AM are right and i am in total agreement with you...
SharePoint (2003/MOSS) is not the right solution for handling system with relation data model.