CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 Help! Dependent listbox troubles!!

Print topic Send  topic

Author Message
charles
Posted: 01/10/2004, 6:17 PM

Hi Folks,
I have struggled with this for two days Now!! I have a record form for
vehicles info for an auto dealer web page.There are two listboxes , one is
make and the child listbox is model.I want it that every time someone
selects a car make, only the coresponding models for that make appears in
the model listbox.I have tried and tried all i know to no avail.
Please someone kindly help me!
Regards,
Charles

Sean Brown
Posted: 01/12/2004, 7:06 AM

Charles,

I have been struggling with the exact same thing for longer than 2 days, so
I know how you feel. I have posted the same questions here, but I have not
received the response that fulfils my goal (although I have received several
ASP examples of dependent list boxes). I do not know how to do this in
CodeCharge Studio, but I know it can be done in ASP. I have also found many
examples in asp101.com, aspin.com, etc.

I do have a "temporary solution"

Database info

tMake tModel
------------------------- ----------------------
-----
id Autonumber id
Autonumber
makeName Text modelName Text
make
Number

What I did is the following until I can figure out the "right" way to do it:
Create your form with your "Make" list box (lists all automobile makes) with
a "Continue" button next to it (when clicked, make it pass the required
parameters to the next page).
Copy that page and record form and name it something else.
Change the list box to list your "Model" information.

Put a Where statement in your "Model" list box to only show vehicles that
match your MakeID.

When you change the Make listbox, have it redirect to your second page with
the MakeID parameter, then it will only show the models with the appropriate
MakeID that corresponds to the make.

Hope this helps.
Sean

"charles" <7919113@multilinks.com> wrote in message
news:btqbn2$79v$1@news.codecharge.com...
> Hi Folks,
> I have struggled with this for two days Now!! I have a record form for
> vehicles info for an auto dealer web page.There are two listboxes , one is
> make and the child listbox is model.I want it that every time someone
> selects a car make, only the coresponding models for that make appears in
> the model listbox.I have tried and tried all i know to no avail.
> Please someone kindly help me!
> Regards,
> Charles
>
>


   


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

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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