On Apr 15, 12:51=A0am, "E W P Appeldoorn" <ursus.k...@[EMAIL PROTECTED]
> wrote:
> Create a script that does the sorting. Specify the sort order, don't
tick
> the 'perform without dialog' box. This defaults to current table, or can
b=
e
> made to default to any layout you might need.
Hi, Ursus -
Thanks for answering. The thing is, if I specify a sort order in a
script, then any time a user tries to sort (whether through custom
menu or button), my specified order overwrites any sort order he might
have used previously.
For example, let's say he opens the database; decides to sort by last
name, company, zip code; goes through the steps of moving those fields
from one side of the sort dialog to another; and sorts. Then he
realizes he actually wants to sort by last name, company, state
(instead of zip), and reopens the sort dialog (custom menu or
button). What does he find? The sort order I specified in my script
instead of the one he just used, so instead of just changing one field
(or more if it's a more complicated sort), he has to clear all fields
that I specified, find each field in the list, move them over again,
etc. In other words, instead of being able to use the sort dialog the
way we do in an unscripted sort -- building progressively on what he's
done before -- his work gets erased each time and replaced with the
specified script.
Instead, I'd simply like it so the left-hand side of the sort dialog
defaults to Current Table, where you'll see a beautiful list of user
fields organized by function in plain English, with all the developer
fields way down below where it doesn't confuse him. Isn't there a way
to do this? Or does FileMaker always default to Current Layout with
no way to specify default to Current Table -- except by overwriting
the user's previous work?
Let me know what you think.
Best,
Jahn


|