Relational Lists in SharePoint 2010

re: Relational Lists in SharePoint 2010

Paolob — Mon, 01 Mar 2010 15:52:45 GMT

Do relational lists in Sharepoint server 2010 preserve all relational constraints? For example is it possible to define a primary key composed by 2 or more columns?

I'm searching also if it is possible, when you insert a new item in a list, filter combo data considering the value set in another field. For exaple if you select the item "Canada" in the first combo box, is it possible to have a second combo box that updates it's data to match canadian towns?

Finally, the new feature that permits to see data from the parent list is available only in views or also when you insert a new item in a list?

re: Relational Lists in SharePoint 2010

CoreyRoth — Tue, 10 Nov 2009 14:56:31 GMT

If you are migrating your application from Access to SharePoint today, it is true that there is no out-of-the-box solution for maintaining referential integrity or for doing joins. You can get around this some, by writing some ItemEventReceivers that enforce the integrity for you but its still not an ideal situation. As for the joins you can write two separate CAML queries and join the results together with LINQ. Again, not really ideal.

SP2010 helps this a bunch because it does have support for maintaining integrity and the query syntax now supports joins.

re: Relational Lists in SharePoint 2010

Al Kizyma — Tue, 10 Nov 2009 14:36:31 GMT

Corey,

I'm in the process of deploying an Access 2007 application on a sharepoint 3.0 site. However I am concerned about the lack of referential integrity and join type and how this will impact my data down the road.

Any suggestions?

Thanks,