CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Listboxfield, that depend on a field on the Form

Print topic Send  topic

Author Message
rainer kaelin
Posted: 09/05/2002, 9:01 AM

Hi,

Example:
- Field1_City:
- Field2_Streets (Listbox)
Feld2_Streets shoud list only the Streets from the entered Field1_City (not
all Streets)

Thanks,
rainer kaelin

Shawn Mason
Posted: 09/05/2002, 9:21 AM

2 alternatives that I can think of and only one makes sense due to the
possible number of streets...both involve javascript

1) store all streets in a js array and filter in on the fly (too many
records really)
2) make the city field a html field and add an "onchange" event to it that
calls a js function
the js function would take the value and submit the page back to the
server similar to

newLocation = "MyNewPage.asp?" + transfer_stuff + "&myCityParam=" +
document.MyPageName.MyCityField.value ;
document.location = newLocation;

The above snippet (you'll need more but this is a start) will repost the
page with your MyCityParam that will tell you new page to fill in the
dropdown with the streets for this city

3) the redisplayed page should now have the city and a dropdown of the
streets to that city (btw, a dropdown of a city like Chicago or New York
might be way, way too large to handle with a dropdown)

Anyway, it is not as easy as I make it to be...it can be done...I've done it
in several places but it can be done. BTW, debugging js code sucks!

--
Kindest Regards,

Shawn Mason,CCD,MCP
I.S. Software Design Associates



"rainer kaelin" <rainer_kaelin@hotmail.com> wrote in message
news:al7v5b$o60$1@news.codecharge.com...
> Hi,
>
> Example:
> - Field1_City:
> - Field2_Streets (Listbox)
> Feld2_Streets shoud list only the Streets from the entered Field1_City
(not
> all Streets)
>
> Thanks,
> rainer kaelin
>
>

rainer kaelin
Posted: 09/05/2002, 10:46 AM

thank you!

The City, Street was only a example. The real table has only 40 Record.

Kindest Regards
rainer kaelin


"Shawn Mason" <shawn@issda.com> schrieb im Newsbeitrag
news:al80ab$qct$1@news.codecharge.com...
> 2 alternatives that I can think of and only one makes sense due to the
> possible number of streets...both involve javascript
>
> 1) store all streets in a js array and filter in on the fly (too many
> records really)
> 2) make the city field a html field and add an "onchange" event to it that
> calls a js function
> the js function would take the value and submit the page back to the
> server similar to
>
> newLocation = "MyNewPage.asp?" + transfer_stuff + "&myCityParam=" +
> document.MyPageName.MyCityField.value ;
> document.location = newLocation;
>
> The above snippet (you'll need more but this is a start) will repost the
> page with your MyCityParam that will tell you new page to fill in the
> dropdown with the streets for this city
>
> 3) the redisplayed page should now have the city and a dropdown of the
> streets to that city (btw, a dropdown of a city like Chicago or New York
> might be way, way too large to handle with a dropdown)
>
> Anyway, it is not as easy as I make it to be...it can be done...I've done
it
> in several places but it can be done. BTW, debugging js code sucks!
>
> --
> Kindest Regards,
>
> Shawn Mason,CCD,MCP
> I.S. Software Design Associates
>
>
>
> "rainer kaelin" <rainer_kaelin@hotmail.com> wrote in message
>news:al7v5b$o60$1@news.codecharge.com...
> > Hi,
> >
> > Example:
> > - Field1_City:
> > - Field2_Streets (Listbox)
> > Feld2_Streets shoud list only the Streets from the entered Field1_City
> (not
> > all Streets)
> >
> > Thanks,
> > rainer kaelin
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.