I have written a script connected to a button in an entry layout that opens a new layout in preview mode to show data organised with two leading sub-summaries.

It sorts ok and gives me the display I want

But as I add various navigation scripts to my original layout then test them, the script relating to preview layout does not always sort correctly giving me a preview without sub-summary information.

I'm pretty sure that it relates to the Sort command in the Preview script...

Am I correct and what can I do about "concreting" the sort command in the Preview script???

TIA

Stephen K

I recommend you break your Sorts out into separate one-line scripts, which you can then call as needed with the Perform Script step.

More...

it happens any time I do a different sort...I have to restore the original sort order needed fo publish correctly

Sorry Tom

was writing my extra as you posted

I'm trying to set up a button/script so that other users can print out the student records...i added the sort into the script so that when other users hit the button...the records in preview can be printed after viewing...then be returned to the original layout after printing.

But if a user hits a find button then goes to preview the sub-summary information isn't present...then on return to original layout...it is sorted according to the sort criteria but on entering preview layout...the sub-summary data is not there.

If I don't allow a find command there is no problem...but if I do any sort...grrr

Do previews with sub-summaries only work with a manual sort before viewing???

Previews with sub-summaries will work with scripted Sorts.

Try inserting Enter Browse Mode in your script before the Sort.

I still recommend you break your Sorts into separate scripts. This is less useful in FileMaker 7, which allows multiple Sorts in one script, but it's a good technique in version 6.

Hey Tom

Thanks...why don't I listen!!!

Soon as I set the Sort as a separate Script all problems (to date) disappeared!!!

Stephen