I have a user that does not want the search results to not be resorted. She uses the add/request to build a search list. Because of other lists she needs to access, she would like the searched data to remain in the order she entered it. The problem is that the search seems to automatically resort. I don't have any sort functions scripted.

Is there anyway to turn this sorting off?

Add unsort. FM10 retains the sort, if done once, "automatically."

Thanks, but it doesn't seem to be unsorted.

Here is what I have, the script enters find mode and searches from one button:

If [Get(WindowMode)=0]

  Enter Find Mode []

Else If [Get(WindowMode)=1]

  Perform Find[]

End If

Unsort Records

I enter

7j

5h

and it returns

5h

7j

Edited April 12, 201015 yr by Guest
added screenshot

The "Unsort" command will sort the records into the order that they were originally entered into FileMaker, i.e. the record creation order.

It sounds like you want the found results to be sorted by the order that they were requested in the Find operation.

That's much trickier.

If you are scripting your Find, I think you may be able to do it, but it won't be simple.

It may go something like this.

1) Memorize the sort keys in the multiple requests just prior to carrying out the Find operation.

2) Perform the Find.

3) Put the memorized ordered list of values into a value list.

4) Sort using the value list to specify the sort order.

This presumes that the query is something relatively simple such as searching on a single name or a single ID.

If the find requests are varied (request 1: find all females, request 2: find guys named Bob), then this method would be quite hairy.

Edited April 12, 201015 yr by Guest

I think I am just going to let this one slide.

thanks