Do you have any script triggers such as OnRecordLoad or OnLayoutEnter that perform a script that also sorts the records? If so, your script may trip that trigger and the records might get sorted to a different order by the scripttigger's script.
If you double click the Sort Records step in the script editor, do you see the correct list of sort fields in the dialog box that opens?
To post a script to the forum:
- You can upload a screen shot of your script by using the Upload an Image controls located just below Post A Answer.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here.
- If You have FileMaker Advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format.
You may need to post your script so that fresh eyes can look at it.
Phil - I'm a bit late in responding to your answer..... but the same 'sort order' issue is happening with a series of scripts. Each of the scripts seem to remember prior 'sort sequences' outside of the script and then when prompted via the script, will not sort according to the script.
It's kind of like the prior sort is not washed out before recognizing the request sort order......
thanks in advance - RR