Pete
|
| Posted: 10/03/2005, 12:09 PM |
|
Hi,
Maybe you can point me to the proper location in the user manual on line that shows an example of how you would perform the following.
I have a complex registration form and the user picks the city he/she lives in and this is picked in a dropdown box tied to a Cities table containing only the valid city selections.
Later on down in the registration form the user now selects a location from another table in a dropdown box tied to another table that has all the available locations where someone could register at, in this case names of Bar Names.
All this works 100%. Now here is what I am after. In the table of Bar Names these records also have a City where the bar is located.
After selecting the city where to user resides when he/she clicks on the bar names to register at all I want to see in this second dropdown list is those bar locations that are in the same city as where the user lives.
I took a good look through the help file on your web site and realize that some form of Select statement is required in the second dropdown list so it only shows the bar locations in the same city as the person who is registering.
I was not able to find anything that provides this. I tried a search for key word "Dropdown" and was hoping to find an example to do what I want, but nothing of this nature presented itself.
Do I am wondering if you have any article you can suggest that give an example like this.
Thanks very much for all your assistance and patience.
|
|
|
 |
DonB
|
| Posted: 10/03/2005, 6:07 PM |
|
Lots and lots of discussion in these forums for what we call the "dependent
listbox" problem. Search on that and you'll find several ways to approach
it.
--
DonB
http://www.gotodon.com/ccbth
"Pete" <Pete@forum.codecharge> wrote in message
news:2434181fe7281c@news.codecharge.com...
> Hi,
>
> Maybe you can point me to the proper location in the user manual on line
that
> shows an example of how you would perform the following.
>
> I have a complex registration form and the user picks the city he/she
lives in
> and this is picked in a dropdown box tied to a Cities table containing
only the
> valid city selections.
>
> Later on down in the registration form the user now selects a location
from
> another table in a dropdown box tied to another table that has all the
> available locations where someone could register at, in this case names of
Bar
> Names.
>
> All this works 100%. Now here is what I am after. In the table of Bar
Names
> these records also have a City where the bar is located.
> After selecting the city where to user resides when he/she clicks on the
bar
> names to register at all I want to see in this second dropdown list is
those
> bar locations that are in the same city as where the user lives.
>
> I took a good look through the help file on your web site and realize that
some
> form of Select statement is required in the second dropdown list so it
only
> shows the bar locations in the same city as the person who is registering.
>
> I was not able to find anything that provides this. I tried a search for
key
> word "Dropdown" and was hoping to find an example to do what I want, but
> nothing of this nature presented itself.
>
> Do I am wondering if you have any article you can suggest that give an
example
> like this.
>
> Thanks very much for all your assistance and patience.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Walter Kempees
|
| Posted: 10/04/2005, 12:34 AM |
|
Tips and Solutions Forum
"Pete" <Pete@forum.codecharge> schreef in bericht
news:2434181fe7281c@news.codecharge.com...
> Hi,
>
> Maybe you can point me to the proper location in the user manual on line
> that
> shows an example of how you would perform the following.
>
> I have a complex registration form and the user picks the city he/she
> lives in
> and this is picked in a dropdown box tied to a Cities table containing
> only the
> valid city selections.
>
> Later on down in the registration form the user now selects a location
> from
> another table in a dropdown box tied to another table that has all the
> available locations where someone could register at, in this case names of
> Bar
> Names.
>
> All this works 100%. Now here is what I am after. In the table of Bar
> Names
> these records also have a City where the bar is located.
> After selecting the city where to user resides when he/she clicks on the
> bar
> names to register at all I want to see in this second dropdown list is
> those
> bar locations that are in the same city as where the user lives.
>
> I took a good look through the help file on your web site and realize that
> some
> form of Select statement is required in the second dropdown list so it
> only
> shows the bar locations in the same city as the person who is registering.
>
> I was not able to find anything that provides this. I tried a search for
> key
> word "Dropdown" and was hoping to find an example to do what I want, but
> nothing of this nature presented itself.
>
> Do I am wondering if you have any article you can suggest that give an
> example
> like this.
>
> Thanks very much for all your assistance and patience.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
