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
>
>
|
|
|
|
|
