Re: Dynamic Menus in Lists

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bob Mixon (bob.mixon_at_vixcorp.com)
Date: 09/21/04


Date: Tue, 21 Sep 2004 14:35:27 -0700

Brad,

What Mike is referring to is the ability to connect Web Parts. Web Parts
can communicate information between each other using what are called Web
Part Connections. A Web Part Connection can be used to filter the contents
of another Web Part. From reviewing your post and what Mike posted, I
believe he was indicating you would create a single custom list. The custom
list would contain a country and state columns. The country would be
duplicated for each associated state. You could then place two Web Parts on
a page, both being derived from the same custom list. The first Web Part
displaying the countries and the second Web Part displaying the states. You
could then connect the Web Parts, having the first one provide a filter to
the second; filtering on the selected country. The only problem I see with
this approach is the duplicate countries that will be shown in the first
view.

The approach I would take is to create two custom lists. The first list
would simply contain your list of countries. The secont list would contain
a lookup column to your country list and a state column. You could then
place a Web Part on your page that displays the countries and a Web Part
that displays the states. You would use Web Part Connections to filter the
second list based on the currently selected country.

The down side to either of these approaches is you more than likely want
this to either be some type of input to another list or a form. Meaning,
the resulting selections would be input and provide control. If you are
wanting this type of functionality, you would have to write it in java
script or .NET. My personal choice is always .NET only because that is the
language I am most comfortable with. You may be able to find a java script
guru here that could help you do it on the client side.

Have you taken a look at a blog called FrontPoint? There is a lot of good
stuff there that might help you out! You can look it up in google.

------------------------
Bob Mixon
http://attunesystems.mywsssite.com

Do You Collaborate?

"Brad Dridi" <bdridi@hotmail.com> wrote in message
news:32bd01c4a009$13148c00$a501280a@phx.gbl...
> This is directed to Mike whom responded with:
>
> I doubt if you can do it that way, but it's easy enough
> to set up on a web
> part page within WSS using various web parts (of the same
> list) and web part
> connections to connect them.
>
> Mike Walsh, Helsinki, Finland
> WSS FAQ at http://wss.collutions.com
> Please post questions to the newsgroup only.
>
> My next question is how do you use web part connections
> and where would I find some basic instructions or
> tutorials for following these steps? My original desire
> is listed below. Thanks in advance.
>
> My original post....
>
> "Brad Dridi" <bdridi@hotmail.com> wrote in message
> news:027401c49517$139ded80$a401280a@phx.gbl...
> > I want to use the formula and calculation functions of a
> > Sharepoint list so that when a user chooses the region
> > from a drop down menu in a list item it populates the
> > next menu drop down with countries in that region.
> >
> > For instance
> >
> > Choice of:
> > North America
> > Africa
> > Europe
> >
> > Next drop down menu will view what was chosen and
> provide
> > pre-entered countries for that region..
> >
> > User chooses North America, next drop down:
> >
> > Pennsylvania
> > New York
> > New Jersey
> > Delaware
> > and so on....
> >
> > User chooses Africa, next drop down:
> > Tunisia
> > Morroco
> > Egypt
> > and so on....
> >
> > Please, please help.
> >
> > Would probably be something like
> >
> > if [region] = North America ???????this is the part i'm
> > missing??????
>



Relevant Pages

  • Re: Dynamic Menus in Lists
    ... you've hit the essence and spotted the possible problem (duplicate ... I tend to use two different lists myself but this ... > list would contain a country and state columns. ... You would use Web Part Connections to filter ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: My only near-negative
    ... What has this to do with your insistence that I abide by rules of a country that I am not abiding in? ... No dictionary of mine lists it. ... It does not have a definition for whittering. ... Why would you suppose that I was denying being aware of "antiques trade" as an expression? ...
    (alt.marketing.online.ebay)
  • Re: plain english
    ... > mike wrote: ... >> is there a website somewhere that lists what exercises work which muscles ... hey, you're too lazy to kill yourself. ...
    (misc.fitness.weights)
  • Re: think when starting: formats (dates, places, ...)
    ... If I'd been starting out now, I'd have used the ISO format - year, ... produce lists of events sorted by place. ... "town/village, country subdivision, country", which means that the list ... the spelling of placenames changes, ...
    (soc.genealogy.britain)
  • Re: think when starting: formats (dates, places, ...)
    ... If I'd been starting out now, I'd have used the ISO format - year, ... produce lists of events sorted by place. ... "town/village, country subdivision, country", which means that the list ... the spelling of placenames changes, ...
    (soc.genealogy.britain)