Re: Dynamic Menus in Lists

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

From: Mike Walsh (englantilainen_at_hotmail.com)
Date: 09/22/04


Date: Wed, 22 Sep 2004 07:28:40 +0300

Yes, you've hit the essence and spotted the possible problem (duplicate
country). I tend to use two different lists (your follow-up) myself but this
means manual work (as you know) maintaining the lists - although with
Country/State being static in this case there probably isn't much
maintainance.

Thanks for picking this up!

Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.

"Bob Mixon" <bob.mixon@vixcorp.com> wrote in message
news:etgQtLCoEHA.3684@TK2MSFTNGP10.phx.gbl...
> 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
    ... What Mike is referring to is the ability to connect Web Parts. ... list would contain a country and state columns. ... The approach I would take is to create two custom lists. ... You would use Web Part Connections to filter the ...
    (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: 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)
  • Re: Using a form entry to update an existing record in a table
    ... Your lists are based on table, ... my problem is not to add a new country if it is not in the list. ... > add Africa from another combo to ... > the region field in the Malawi record in the tblCountry. ...
    (microsoft.public.access.formscoding)