Cascaded Lookup: Finally, a Simple Solution by SharePointBoost(referrence)

Without fail, when I and other Officetalk SharePoint Consultants are assisting with SharePoint projects we get the dreaded question: "Yes, but how do I add another level to the list?". Ok, the wording changes, but they all want to have a drop-down list based on the entry they entered on a previous list…

The basic SharePoint Lookup feature is quite basic and just gives a list of the entries on another field on the current site. Yes, with SharePoint Designer and Data Views you can combine data from lists on several sites, but it is quite a complex process. Out of the box SharePoint falls short here, but SharePointBoost's Cascaded Lookup takes it to the next level.

Being a football fan (the great Aston Villa) I have used Cascaded Lookup to set up a European Players list. It starts with all the European Countries and the leagues in each and then has a list for each of the teams in each league. So, now using Cascaded Lookup the user can enter an individual players’ details and have a field called 'Team' that is filtered first by Country and then by League.

cascaded-lookup

Bottom Line:

It may get slightly confusing when trying to add a secondary filter (i.e. filtering City by Continent and then by Country), but overall Cascaded Lookup is a simple, but a very useful tool. It is also very reasonably priced, and offers a free 30-day trial.

Written by Andy Dale

Some Posts You Need Take A Look Most!

Q:
I have search for probable answer to this, but I can't seem to get it working.
I have a MOSS 2007 that uses the computer name as the default url name, how can I change this url to something else such as the name of the company.
Also, I can achieve this during actual set up of the MOSS farm.


A: Here is a quick procedure:
1)Open up your IIS
A)Expand the Web Sites folder
B)Right click on the site that you are using.
C)Click on Properties.
D)Make sure you are on the Web Site tab and click on the advanced button by IP address box.
E)Click Add and enter the following values:
i)IP address: (All Unassigned)
ii)TCP port: (use the port number associated with your site)
iii)Host Header Value: collaborate.kwd.ad.kellwood.com/sites/
iv)Click OK, OK, OK
2) Open Central Administration
A) Click on the Operations tab
B) Under the Global Configuration section, click on Alternate Access Mappings
C) Click on Add Internal URLs. Enter the following values.
i)Alternate Access Mapping Collection: Change the alternate access mapping collection to your site
ii)URL, protocol, host and port: collaborate.kwd.ad.kellwood.com/sites
iii) Click Save
3) Now you need to update the DNS to point to your SharePoint Server.



Q:
I am wondering about the login prompt and if it is appearing too often. When I 1st access my sharepoint site it pops up and asks me to login, no problem with that, however if I go to a document library and open a word doc, each time I open the word doc I am prompted to log in again, this is very annoying and is this necessary or can I switch it off?


A:
Option One: Put your site either in a) Trusted Sites (IE6)
or b) Intranet Sites (IE7)
then you shouldn't get the additional login when opening a word doc. If you are working in a domain, you will probably be able to avoid the first login by changing your Login settings for the security zone of the site to "Automatic login using current name and password.
Q:
If the document is checked-out to me in a document library, they are not visible to other users (administrator or contributor) on site.

How do I make them visible to others they are checked-out to me?

A:
Go to document library settings-> versioning settings, then select “Any user who can read items” for “who should see draft items in this document library?”

Q:
I have an excel report done with Performance Point Server and is deployed on a SharePoint site. Now in my SharePoint site I am able to see that report as it is deployed but what I also see is a scroll bar. If I click on modify shared web parts and if I change the height then I will not see the scroll bar but I don’t want to change the size.
Is there any way to hide that scroll bar??


A:
Give this shot. Had the same problem this seems to work for me....
I created a new aspx page via SharePoint designer.
Add web part zone, add excel web access part & configure to show your excel file.
Attach your master page.
Ok to the scrollbars:
To remove the horizontal ones change the "columns to display" to something low like 10 or 5.
This can be done on the web part itself.
For vertical, go to the web part properties in SharePoint designer (should be on left hand side).
Change the height to something big like 1000px. This should remove the horizontal scrollbars.
Now, the trick is to slim down the height little by little so you aren't scrolling way down the page to see the footer.
For my application, a web part height of 775px is just right for displaying 50 excel rows.
-with that, my worksheet will never be larger than a max of 50 rows. if your height will be dramatically changing on a frequent basis then this probably won't be your best bet. But it's an option for those who don't need dynamic sizing (which I have no idea how to do).

Q:
We deployed SharePoint 2007 Server, in which we have a document library. We have couple of content types. These content types have some columns; and for one column there is a parent child relationship. When user selects first column (parent) second column (child) values should be filtered based on parent column selection (basically getting Country and state functionality; when user selects country in first drop down list all the states of that country should be filtered and displayed in second column drop down box. It is just kind of “list in list”.
A:
I don't believe this functionality is available natively in MOSS2007. If it's critical that you need it, you can either custom code your own web part to pull the two lists together, or look at someone like CorasWorks that provide this functionality as part of their plug-in product. In my case I am using a tool called SharePoint Cascaded Lookup, which works fine. I recommend you take a look at it.