IsEmpty Function

[Mary Office Manager]

I have expenses that I approve. Our financial dept. will have a separate File Maker db. On their opening script...I want them to only see "approved" records. So far I have the following...

Perform Find []

If [not IsEmpty ( IsAdminApproved );:;""]

End If

I don't know what to use for logic for result1 ( and is result2 correct? If there is NOT a value in the "IsAdminApproved" field, then I don't want to show the record.

Please advise.

[Raybaudi]

Hi

Make a script of only one step:

Perform Find [ Action : Omit Records ; Omit records when: IsAdminApproved ; criteria: =]

Don't worry if you'll see only:

Perform Find [ Restore ]

[Mary Office Manager]

Hello,

Thank you SO much. That worked wonderfully!

I appreciate your quick response.

Take care,

Mary