Groups > comp.databases.filemaker > #2111

Re: Problem in Setting Up a Script Sort

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!news.etla.org!aioe.org!.POSTED!not-for-mail
From	Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups	comp.databases.filemaker
Subject	Re: Problem in Setting Up a Script Sort
Date	Wed, 18 Mar 2015 18:26:10 +1200
Organization	Aioe.org NNTP Server
Lines	34
Message-ID	<180320151826106831%HelpfulHarry@BusyWorking.com> (permalink)
References	<1m1fyqf.ov474b1lzxpn9N%csampson@inetworld.net>
NNTP-Posting-Host	bweFT7vR/5o+lFHWr//+BA.user.speranza.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	8bit
X-Complaints-To	abuse@aioe.org
User-Agent	Thoth/1.8.4 (Carbon/OS X)
X-Notice	Filtered by postfilter v. 0.8.2
X-Face	vIZzK[X\z-._]-_:U?l@cBtwg<{a>ggn\mH}Vs>38E,#R%7h%U0'=4;1Q=erO %[T#a{YJfGvAbWmE@f_h]<rQ30+q;vqA^FUVx%\9{@r{gt${p^.L~bemFF@WY$r9fhuA F"1)$0+MgN+j8OO<SAec%$P;!M4Aj/kVitK5\xKmed-/3$2LiT1nI!-lKjt0B!qP_E{V ja+\#+[_uq8",IkoIF3M0}}qCD(&
Xref	csiph.com comp.databases.filemaker:2111

Show key headers only | View raw

In article <1m1fyqf.ov474b1lzxpn9N%csampson@inetworld.net>, Charles H.
Sampson <csampson@inetworld.net> wrote:
> 
> I have a recurring but not consistent problem with sorting in a script.
> From time to time I get into a situation where, when trying to specify
> the sort parameters, I'm only allowed to choose fields from something
> that ScriptMaker call "Current Table" and it's not the table that I want
> to sort. All other tables are greyed out in the drop-down menu.
> 
> It doesn't happen every time. I've tried such unlikely things as
> changing the mode I'm in while working on the script. Browse, Find,
> Layout, or Preview makes no difference.
> 
> What am I doing wrong?

Just a complete guess, but maybe the current record doesn't have any
related records in other tables to sort with.

You could try adding Sort commands to Scripts in the old way:

   - enter Browse Mode with a set of records

   - manually Sort the records by the required field(s)

   - go to the Script and insert the Sort command,
     making sure to set the "Restore" option on
     (assuming newer versions of FileMaker still have
     the Restore option)

Just remember whenever editing that Script from then onwards to tell
FileMaker to "Keep" the stored Sort Order (instead of replacing it with
whatever the current Sort Order happens to be at that editing time).

Helpful Harry  :o)

Thread

Problem in Setting Up a Script Sort csampson@inetworld.net (Charles H. Sampson) - 2015-03-17 18:51 -0700
  Re: Problem in Setting Up a Script Sort Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-03-18 18:26 +1200
    Re: Problem in Setting Up a Script Sort csampson@inetworld.net (Charles H. Sampson) - 2015-03-18 13:56 -0700
      Re: Problem in Setting Up a Script Sort Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-03-19 13:26 +1200
        Re: Problem in Setting Up a Script Sort Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-03-19 16:08 +1200
        Re: Problem in Setting Up a Script Sort csampson@inetworld.net (Charles H. Sampson) - 2015-03-20 00:00 -0700
          Re: Problem in Setting Up a Script Sort Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-03-21 09:51 +1200
  Re: Problem in Setting Up a Script Sort Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2015-03-18 10:39 -0700
    Re: Problem in Setting Up a Script Sort csampson@inetworld.net (Charles H. Sampson) - 2015-03-20 00:00 -0700

csiph-web