Re: FMP Container
Re: FMP Container
- Subject: Re: FMP Container
- From: ehsan saffari <email@hidden>
- Date: Wed, 23 Jan 2002 04:33:12 -0600
On 23/01/2002 00:03, John McAdams <email@hidden> wrote:
>
Is there a way to find out if a container field in FileMaker is empty?
>
The example syntax in the "Find Script" works on regular text fields:
>
>
show (every record of database 1 whose cell "First Name" = "")
>
>
However I can't get it to work on a container field. The idea is to find
>
all the empty pictures fields, grab the file name from a text field,
>
search a folder for the image and then place it into the picture field.
' ="" ' won't work for container fields in FMP find mode either.
Make a new number field and set it to 'IsEmpty(container)'. It will
display 1 for all records with an empty container.
show (every record of database 1 whose cell "duds" = 1)
cheers
ehsan