Re: Finding a list of things in FMPro
Re: Finding a list of things in FMPro
- Subject: Re: Finding a list of things in FMPro
- From: Nigel Smith <email@hidden>
- Date: Fri, 23 Jan 2004 09:36:02 +0000
On 22/1/04 23:59, "Malcolm Fitzgerald" <email@hidden> wrote:
>
> Unfortunately, I can't get it to work when run as a ScriptMaker step within
>
> FMPro 4 -- problems referencing the correct database to create the requests
>
> in, or one DB being left "paused" during the script -- so I shall be using
>
> my version for that job.
>
>
I've never had any problem scripting multiple requests in v4 or v5.
>
Of course, calling the correct database is important. ;-)
Don't I know it! Calling an external script to do the search -- how I
normally develop my FMPro scripts -- worked fine, it was only when I tried
to embed the finished script into a ScriptMaker step that things went
wobbly...
>
If you are only doing "find x or y" then an alternative to "finding"
>
is to use relationships. Set up a relationship between a global text
>
field and cell "fruit". Pop your list of fruit into the global field
>
and "show related records only".
Of course, the actual db is not as simple as the examples given :-) The only
reason I'm even doing this is to get round FMP's portal searching
limitations, where searching on two portal fields gives all related records
which match either of those fields. What I want are the records which match
*both* the fields. I normally get round that by having a search field that
is a concatenation of both (or all) fields I'm interested in, but this time
one is a date, and I want to do greater than, less than, and so on.
Any other suggestions on how to get round this would be great, but probably
should be sent off-list as the AppleScript quotient drops. If anyone is
interested in any answers I get, drop me a private email.
Nigel
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.