Hi.

I am having a bit of a problem. I am hoping someone can help. I can find everything great but if i go to sort the results I get all the records in the database - not the ones I found. I have tried tokens and cookies but they are just not working. I am using FM 4 so i can only pass one token.

I was trying to pass the EmployeeName field. Any help in the right direction would be greatly appreciated.

Post your form code and I'm sure you'll get some help...

Ok you asked for it, you got it

this is what I am using to find my records:

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

<INPUT TYPE="hidden" NAME="-db" VALUE="InMailbox.Fp3">

<INPUT TYPE="hidden" NAME="-format" VALUE="mnc/elist.htm">

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

<P>View email for<BR>

<select name="EmployeeName">

[FMP-option: EmployeeName, list=EmployeeName]

</select>

<INPUT TYPE="hidden" NAME="-LOP" VALUE="AND">

<P>Find<BR>

<input type="hidden" name="-Op" value="eq">

<select name="Status">

<option selected>--Choose One---

[FMP-option: Status, list=Status]

</select>

<input type="hidden" name="-Token" value="[FMP-field: EmployeeName]">

<P>

<INPUT TYPE="submit" NAME="-find" VALUE="View">

<input type="reset" value="Clear Form" name="reset">

<P> 

</FORM>

And this is what I currently have as the sort script (I have tried other ways and nothing was working, i have used -sort)

<a href="FMPro?-DB=InMailbox.fp3&-Format=mnc/elist.htm&-Script=Sort+by+Employee+Name&-Token=[FMP-CurrentToken][FMP-CurrentFind] [FMP-FindOpItem][FMP-FindFieldNameItem][FMP-FindFieldValueItem] [/FMP-CurrentFind]&-find" CLASS="Title">Employee</a>

I am sure its staring right at me - but help!

You can use the -sortfield tag

<INPUT TYPE="hidden" NAME="-sortfield" VALUE=" EmployeeName">

Or, is the sort on a concatenated field?

All the best.

Garry

[ June 07, 2001: Message edited by: garrycl ]