English
Imagine a business scenario where we have a lookup field in our list. The reference list contains items Title and their status. Previously it always difficult to create filtered lookup field with minimal development task. But now, we can use InfoPath 2010 to achieve that functionality.
Part III , InfoPath 2010 and SharePoint 2010 Productivity series webcast shows how to create filtered lookup field. There are two lists in the scenario “Books” and “Members” list. The Books list contains list of books Title, Author and Status. There are 2 status of books, “Available” , “In-Used” and “Missing”.
“Members” list has Books , lookup field – which should show only the “Available” books.
Get the Flash Player to see the wordTube Media Player.
Can we do the same thing without using InfoPath forms?
Thanks in advance.
Hi Dhiraj,
Using Client Object Model, you can achieve the same using SharePoint Designer.
For more information visit other post here:http://blog.libinuko.com/2011/01/29/sharepoint-2010-how-to-create-cascading-lookup-field-using-client-object-model/
Thanks,
Riwut
Hi,
Which program did you used for create these webcasts?
Please let me also know which resolution do you have.
Thanks a lot for your answer
Lutfuth
Hi,
I am using Camtasia Studio.
Hello Riwut,
Thank You very much for your video, It helped me a lot for couple of projects i was working on. I was going through another issue, i was wondering if you might be able to help me.
Lets assume scenario you used in this article "Books" and "Members List" where we have Title, author and Status. So using your technique now we can display title of the books that are available when we create new item in "Members List".
IS there a way that, after you create new item in "Members List" we can update status of "Books" list to " In Use". SO upon creation of another new item in "Members List", we wont see same item being displayed.
I would really appreciate your help.
Thank You