R
ron
First I have a database for the church that will have the councilors. I
want people when they click on a link for councilors to first see a "Drop
down box" where they can pick a town based on a field in the database. The
default that front page uses when I use the data base results wizard puts a
text box that they have to type in the town to search for and I want a drop
down box that pulls all the towns out of the town fields in my database. I
know it is possible but do not remember how it was done.
Second when they go to the page to use the drop down box I would like it
not to show all the blank fields listed. I just want the drop down box after
they make there selection than show all the fields that match.
And finally in each town we have say 6 people to counsel at different
nights. Once they select the town from the drop down box go to another box
where they could select from a night of the week and only the person from
that town in that night of the week show up on the screen. I have all this
info in the database.
In advance thank you so much for the help and god bless.
Lishron
want people when they click on a link for councilors to first see a "Drop
down box" where they can pick a town based on a field in the database. The
default that front page uses when I use the data base results wizard puts a
text box that they have to type in the town to search for and I want a drop
down box that pulls all the towns out of the town fields in my database. I
know it is possible but do not remember how it was done.
Second when they go to the page to use the drop down box I would like it
not to show all the blank fields listed. I just want the drop down box after
they make there selection than show all the fields that match.
And finally in each town we have say 6 people to counsel at different
nights. Once they select the town from the drop down box go to another box
where they could select from a night of the week and only the person from
that town in that night of the week show up on the screen. I have all this
info in the database.
In advance thank you so much for the help and god bless.
Lishron