Create a script that does the Show All Records and then does the sort again. Apple that script to a button on the layout.
Thank you David for your prompt response… I was hoping there was a setting I could checkup or something, so that the SHOWALL button in the Status ToolBar would do the sorting again… to avoid cluttering the report with yet another button to run the script, as you suggest and which I have tried and works…
If you make a custom menu set for that report layout, you can set the "Show all Records" command to run your script.
The button in the toolbar will join right in.
This will keep your layout cleaner and has the added benefit of preventing your users from accidentaly pushing the wrong button or menu command.
**note** This requires FMP Advanced.
hope that helps,
Thank you Greg so much! I Will do that!
Sent from my iPhone