Re: FMP Container
Re: FMP Container
- Subject: Re: FMP Container
- From: Kai Edwards <email@hidden>
- Date: Thu, 24 Jan 2002 19:06:35 +0100
>
Date: Thu, 24 Jan 2002 00:36:35 -0500
>
Subject: Re: FMP Container
>
From: John McAdams <email@hidden>
>
To: email@hidden
>
>
Thanks for all the responses. The easiest solution is, indeed, to create
>
a calculation field that tests the container field. You can then use the
>
calculation value to find, sort, show, etc. ala Malcolm Fitzgerald's
>
suggestion:
>
>
> Filemaker has an isempty() function. Why don't you set up a calculation
>
> field, e.g., imageExists, which consists of:
>
>
>
> isempty("container field")
>
>
>
> then you can get applescript to
>
>
>
> show (every record of database 1 whose cell "imageExists" = 1)
Yeah. Why on earth I didn't use the 'isempty()' function directly to return
a Boolean value - rather than wrapping it up in a clumsy if/then comparison
beats the hell out of me. My only excuse is that I'd just driven some 350
miles in dreadful weather - so my brain must have still been a bit numb!
Still, I'm delighted you landed a satisfactory solution. (I guess one of the
benefits of the list is that, instead of an answer that merely works, we
often get the one that works best.)
Kai
--
**********************************
Kai Edwards Creative Resources
1 Compton Avenue Brighton UK
Telephone +44 (0)1273 326810
**********************************