ok here is what i am trying to do. its not that important, its just something that would be nice to have on the page. I am trying to put something on the bottom of the search results page that will let me resort the search result by a different field.. not exactly sure how to do this.. This is what i tried already but it didn't work..

<FORM ACTION="FMPro" METHOD="POST">

<INPUT TYPE="hidden" NAME="-db" VALUE="caddrawingdb.fp3">

<INPUT TYPE="hidden" NAME="-lay" VALUE="Drawing Entry Form">

<INPUT TYPE="hidden" NAME="-error" VALUE="errors.htm">

<INPUT TYPE="hidden" NAME="-format" VALUE="formats.htm">

<P align="left"><B><FONT SIZE="-1">Sort Results By:   <SELECT NAME="-sortfield">

<OPTION SELECTED>Model Number

<OPTION value="ActivityIDNumber">Activity ID Number

<OPTION value="Drawing Number">Drawing Number

<OPTION value="revdate">Last Change

<OPTION value="drawtype2">Metric or English

<OPTION value="drawingtype">Drawing Type

<OPTION value="prodopts">Product Options

<OPTION>unsorted

</SELECT>

   

<SELECT NAME="-sortorder">

<OPTION SELECTED>ascending

<OPTION>descending

</SELECT>     <INPUT TYPE="submit" NAME="-find" VALUE="Sort">

</FONT></B></P>

</form>

<OPTION VALUE="ascend" SELECTED>ascending

<OPTION VALUE="descend">descending

still having problem... the problem is that none of the results are showing up.. they all just disapear instead of resorting?

When sorting on Model Number, I'll bet.

Try this:

<SELECT NAME="-sortfield">

<OPTION>unsorted

<OPTION value="Model Number" SELECTED>Model Number

<OPTION value="ActivityIDNumber">Activity ID Number

<OPTION value="Drawing Number">Drawing Number

<OPTION value="revdate">Last Change

<OPTION value="drawtype2">Metric or English

<OPTION value="drawingtype">Drawing Type

<OPTION value="prodopts">Product Options

</SELECT>

well thanks for noticing that. but it still doesnt fix my problem.. it comes up with no records no matter what i sort by..

maybe i am just way off on how to do it.