sub html_view_search {
# ---------------------------------------
# This page is displayed when a user requests to search the database for viewing.
# Note: all searches must use GET method.
#

$page_title= "Search the Database";
&html_page_top;

$submit_button = "Search";
$reset_button = "Reset Form";

# < -- Start page text -- >
print qq|
<TABLE CELLPADDING=3 CELLSPACING=0 BORDER=1
BGCOLOR="#FFFFCC">
<TR><TD VALIGN="TOP"><$font>Location (please specify
<b>ONE OR MORE</b> areas
where you would prefer to meet with an advisor):</font></TD>
<TD VALIGN="TOP"> |;
print
&build_checkbox_field("Location","$rec{'Location'}"); print
qq|</TD></TR>

<TR><TD VALIGN="TOP"><$font>Fee (please specify whether you have a fee structure
preference - select <B>ONLY ONE</B> ):</font></TD>
<TD VALIGN="TOP"> |;
print &build_radio_field("Fee","$rec{'Fee'}"); print qq|</TD></TR>

<TR><TD VALIGN="TOP"><$font>Client Type (Most advisors deal with a wide variety
of clients; however, some have a special interest or expertise in certain types of clients.
If it is important to yo to deal only with someone with a special expertise, please check
<B>ONE OR MORE</B> of the options available. Otherwise, you may <B>SKIP</B> this section.):</font></TD>
<TD VALIGN="TOP"> |;
print &build_checkbox_field("Client_Type","$rec{'Client_Type'}"); print qq|</TD></TR>

<TR><TD VALIGN="TOP"><$font>Minimum Portfolio (Some advisors have minimum investment
amounts; selecting one of these options will allow you to avoid considering an advisor whose minimum
exceeds your portfolio size. You may <B>SELECT ONE</B> or <B>LEAVE IT BLANK</B>.):</font></TD>
<TD VALIGN="TOP"> |;
print &build_radio_field("Minimum","$rec{'Minimum'}"); print qq|</TD></TR>

<TR><TD VALIGN="TOP"><$font>Planner Expertise (All advisors here provide
comprehensive financial planning; however, some advisors also have a special interest or expertise
in ertain areas. If it is important to yo to deal only with someone with a special expertise,
please check <B>ONE OR MORE</B> of the options available.):</font></TD>
<TD VALIGN="TOP"> |;
print &build_checkbox_field("Expertise","$rec{'Expertise'}"); print qq|</TD></TR>
</TABLE>
|;
# < -- End page text -->

print qq|
<form action="$db_script_url" method="GET" name="form1">
<input type=hidden name="db" value="$db_setup">
<input type=hidden name="uid" value="$db_uid">
|;

# &html_record_form();

# &html_search_options;

print qq|
<p><center>
<INPUT TYPE="SUBMIT" NAME="view_records" VALUE="$submit_button">
<INPUT TYPE="RESET" VALUE="$reset_button">
</center></p></form>
|;

&html_footer;
&html_page_bottom;
}

print qq|
<form action="$db_script_url" method="GET" name="form1">
<input type=hidden name="db" value="$db_setup">
<input type=hidden name="uid" value="$db_uid">
|;