need help with 3 things

[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

 

[Kathleen Anderson]

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.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q235554&GSSNB=1


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.

How are you outputting your query results? If it's in Paragraph format, try this:

Wrap the DatabaseResultColumn bot in some script that checks to see if it
has a value. Switch to HTML view, add the script, and save your change while
you're still in HTML view.


<% If fp_rs("Municipality") > " " then %>

<li><b>Municipality:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
startspan
s-columnnames="ProgramArea,RecordNum,Date,ItemNumber,SplitItem,Session,PA_SA
,ActNumber,Section,Recipient,Municipality,FundsUse,DollarField1,DollarField2
,DollarField3,DollarField4,Any_Previous,DollarField5,FundNum,AgencyNum,SID,P
roject_Num,Description"
s-column="Municipality" b-tableformat="FALSE" b-hashtml="FALSE" clientside
local_preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Municipality&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Municipality&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_r
s,"Municipality")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="33247" endspan --></li>

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.
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm


In advance thank you so much for the help and god bless.

Lishron

HTH,


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/