I have a list which has a Country lookup.The Country list has a Continent lookup.How can I filter my original list by continent.It would be ideal to do this without reorting to custom web parts.

Free tool you can try thiscascaded lookup dropdowns in a SharePoint http://spcd.codeplex.com/ http://datacogs.com/datablogs/archive/2007/08/26/641.aspx3rd Party toolshttp://infowisesolutions.com/product.aspx?id=ConnectedFields2007http://www.sharepointboost.com/cascaded-lookup.htmlK.Mohamed Faizal, Solution Architect, Singapore http://faizal-comeacross.blogspot.com/

Not quite what I'm after.I had contemplated using cascading drop-downs but I don't want the user to have to select Continent at all. If they have selected a Country then the Continent is implied by the relationship between them and what I'd like to is filter my list on on Continent.So I have: List --> Country --> ContinentEach arrow is a Many - 1 relationship.I can get list items for a specific country and by extension, it would be nice to provide a filtered list based on the relationship between Country and Continent.In the first link you provided for the cascading lists, the user has to select both the country and the city. Why select the country at all. We know what country a city is in.

Hi, I think you can do some coding with web parts connection to achieve your need. Here is as article similar with your need: http://www.carlosag.net/Articles/WebParts/moreRealSample.aspx Here are some sources about web parts connection: http://msdn.microsoft.com/en-us/library/ms178187.aspx http://msdn.microsoft.com/en-us/magazine/cc188696.aspx http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/a636f5cb-0ee4-4451-98a9-260ef4dd4006 Hope it is helpful!Seven