Changing Default Field List in Sort Dialog

External Since: Apr 14, 2008 Posts: 24

Hello -

I'm wondering if anyone has a solution to the way the sort dialog
opens when users choose Sort Records... (this is FM 9, Mac &
Windows). The dialog that opens appears to always default to the
Current Layout set of fields rather than Current Table, whereas the
Current Table field set would be much better for my users (organized
according to function with specific sort fields at the top).

I know I can script the sort function using custom menus etc. to
always open with a specific set of fields on the right-hand side, but
that can be frustrating for users who do a custom sort, realize they
wanted it done slightly different and reopen the sort dialog only to
find all the fields they'd dragged over to the right-hand box have
reverted to the scripted default. Is there a simple work-around so
Current Table always shows in the left-hand box? Any suggestion would
be great.

Thanks.

-Jahn

External Since: Apr 15, 2008 Posts: 4

"jahn" <jahnbigbooty.RemoveThis@yahoo.com> schreef in bericht
news:39c11119-e9c6-4816-afd2-4bffbf655108@y18g2000pre.googlegroups.com...
> Hello -
>
> I'm wondering if anyone has a solution to the way the sort dialog
> opens when users choose Sort Records... (this is FM 9, Mac &
> Windows). The dialog that opens appears to always default to the
> Current Layout set of fields rather than Current Table, whereas the
> Current Table field set would be much better for my users (organized
> according to function with specific sort fields at the top).
>
> I know I can script the sort function using custom menus etc. to
> always open with a specific set of fields on the right-hand side, but
> that can be frustrating for users who do a custom sort, realize they
> wanted it done slightly different and reopen the sort dialog only to
> find all the fields they'd dragged over to the right-hand box have
> reverted to the scripted default. Is there a simple work-around so
> Current Table always shows in the left-hand box? Any suggestion would
> be great.
>
> Thanks.
>
> -Jahn

Jahn,

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 be
made to default to any layout you might need.
Disable the sort from the menu with a custom menu, so your users can't use
that any more. Then make a button on your layout-that fires the script. If
you only need onbe table to be referenced you could also re-route the ctrl-s
with a custom menu, so ctrl-s will trigger your script instead of the
standard sort.. If your are a bit into scripting you could make it so that
ctrl-s always fires a main script, which then branches out for each table
you need.

something like:

if current layout is A
do this sort
if current layout is B
do that sort
etc
end if

Remember to NEVER work on your original menu-set, but always start out with
making a copy and working on that. If you screw up using the original set
you might loose access to you file.

Keep well, Ursus