I'm using FMP 11 and will be displaying the info to my users via the
web sharing feature. In ti you have the ability to do a find and add
in expressions BUT one area we're finding it not working is searching
on a Drop Down Field for a Null so it only displays those items that
are Null. I can do it in other fields with out any issue, anyone have
an idea oh how to do this?

If not able to, then HOW do you set the drops down to have a DEFAULT
of N/A and then do filtering on N/A?

Thanks
Chip

"Chip" <osxfreak (AT) gmail (DOT) com> wrote

Fields formatted as Pop-up Menus or Lists are still simply normal Fields
underneath, so you can set the Field Definition to auto-enter any value
(e.g. "N/A") you want when a Record is created.

I'm not sure if it will work via web sharing, one way around the problem of
performing a "null" search would be to use a secondary screen with a Global
Field and a second Value List which includes a value of "{empty}" for users
to choose. A search Script could then perform the search after recgonising
the "{empty}" means doing a null search.

Helpful Harry )