>> I'm resigned to the not-very-pretty workaround of using request/find
>> commands in the place of "every record whose". I've seen the other
>> recommended solutions, including some promising stuff in AS Studio from
>> Christopher Green, but I'm still too mired in FaceSpan 3.5 to attempt the
>> jump to AS Studio.
>>
>
> I'm guessing that you've seen so AS Studio apps that "help" FMP and
> that you are using FaceSpan to do similar stuff? Have you thought of
> using FMP itself as the helper application? I design helper databases
> that are used to act as interfaces for the databases. They don't
> store data - they simply act as an aid to users, eg., a dialog
> box/gui/widget. You can pass info into global fields in the widget
> which store the information needed for the job at hand. FMP has good
> support for AppleScript so you can get the widget to do all sorts of
> stuff - just like FaceSpan or ASStudio. The widget database can have
> relationships to the "proper" databases, so you're "every record
> whose" problem is a lightning fast "Show Related Record". Very handy
> for complex data entry situations, they can act just like a pop-up
> window.

Agreed that Filemaker makes a good front end, or applescript front end, to
itself. The problem I've encountered with this is if you want to use
applescripted finds, the "find" statement puts the document in Find mode.
Have you found a way around that?

One way I've dealt with it is by putting a standard FileMaker "Find" script
in the files. That just does perform Find [no restore]

When done EXTERNALLY (from an external applescript, from Facespan, whatever)
this works:

Tell application "FileMaker Pro"
Tell document 1
Delete every request
Set NR to (Create new request)
Copy "Seattle" to cell "City" of NR
Find
End tell
End tell

IF done *within* FileMaker in a perform applescript step:

Delete every request
Set NR to (Create new request)
Copy "Seattle" to cell "City" of NR
Find

Leaves you in Find Mode.

So my workaround has been

Delete every request
Set NR to (Create new request)
Copy "Seattle" to cell "City" of NR
Do script "Find"
-- standard ScriptMaker script
-- as defined above