I have a great new solution that's working excellently through except
for one thing: from the entry screen, user can choose to look at
everything in db by going to the preview mode of a report. Clicking
"continue" takes user back to the same input screen. Trouble is, user
comes back to re-sorted records and has to hunt for record being input
at the time.

The preview report must be sorted on all the records as a sub-summary
of one of the fields. But I don't know how to get user back to the
entry screen at the same record that s/he was at before the preview
and sorted the same way as before preview. Sometimes I've sorted
alphabetically and other times by record #, etc yet best scenario
would be to have records in same state as prior the preview.

Can this be done? Tx! D

If you're using FileMaker 7 there is a reasonably easy way to do what
you're asking. Instead of using the existing window and messing up the
sort order etc., simply open another window, maximize it, and do
whatever you need to do in it. Once everything is done, close the
window again. From the users point of view they don't even know they
weren't in the same window.
I would advise you to do all this with allow user abort off so that the
user doesn't stop the script and end up with 2 windows open.
Just some advise, commit the record in the original window before you
open the new window so that you don't get into the trap of trying to
modify the same record in 2 windows.

On 30 Aug 2005 23:08:42 -0700, "FP" <a (AT) pottnerconsulting (DOT) ca> wrote:

(Oops, sorry, forgot to mention my version number. I have version 6.)

Okay re user input, makes sense. Can user still scroll through the
records by page in this "dummy" preview, though?

Do you know the header of any particular thread that might be accessed
in the archives that details how to do this; or perhaps more easily,
does the above technique go by any particular name? That way, it'll
be easy to hunt down the instructions on how to do the above. Tx.

If you're using FM6, the best I can offer is to set a global field to
the unique ID of the record, run your print script then go to related
record based on the global ID. This will not change the found count
but your records won't be sorted anymore.