But there are still some things to improve... for instance, SharePoint 2010 still doesn't have filtered lookups and you can only lookup thing in the same sitecollection. In this post I will look at some new features and some things that should be improved (in my opinion).
The new stuff
Concatenate fields
In SharePoint 2010, you can concatenate fields from the remote list when creating a lookup. This means that you can now - for example - create a lookup to a list of contacts which displays the first name, last name, position and email instead of full name or first name or last name.Data integrity
Another cool thing is data integrity: you can prevent an item from being deleted that has other items connected to it or cascade the delete, ie deleting all dependent items.Let's say you have a project list and project tasks list, where a task is connected to a project.
So, by deleting a project you can make sure that all that project tasks are also deleted.
Or - if you'd like, to prevent deleting a project with active tasks! which can be very helpful.
Reversed Look up
There's also news on reversed lookup. SharePoint 2010 does not fully support reverse lookup fields, however it does have a new API for getting all related items for a specific list items.This is how it works: the new API will get all items in SharePoint that have a lookup that is connected to the current item. The API comes with a new web part which you can drop at any listitem viewform to see its connected items.
0 comments:
Post a Comment