Hi Gurus,

Can someone help a noob :-)

I have created some cities, some clubs and some training-centers.

On each club/trainingcenter I have a contentpicker that points to the city, but how do I show which clubs and centers are present in the current city?

my current code looks like this:

    @{
        string nodeSel = Model.MapCityNodePicker.ToString();
        string nodeSelClubs = Model.MapClubNodePicker.ToString();
        string nodeSelCenters = Model.MapTrainingCenterNodePicker.ToString();
        string nodeSelDevCenters = Model.MapDevelopmentCenterNodePicker.ToString();

        var selection = Umbraco.TypedContent(nodeSel).Children("city")
                    .Where(x => x.IsVisible());
    }
    <ul>
        @foreach (var cityItem in selection)
        {
            var selClubsInCity = Umbraco.TypedContent(nodeSelClubs).Children("clubs").Where(x => x.IsVisible()));       
            <li>
                @cityItem.Name, Klubber: @nodeSelClubs, Talent: @nodeSelCenters, Udv.centre: @nodeSelDevCenters - @selClubsInCity.Count().ToString()

                <ul>
                    @foreach (var clubsItem in Umbraco.TypedContent(nodeSelClubs).Children())
                    {
                        <li>@clubsItem.Name, @clubsItem.cityPicker - @cityItem.id</li>
                    }
                </ul>
            </li>
        }
    </ul>
}

My question is how do I only get the clubs that has the "current" club selected? I'm guessing I have to write a ".Where(x => ..." but I can't seem to find the correct syntax

I hope someone can help me and make it all more clear :-)

/Jimmy Dan Mortensen