search filtering

[joen0s]

Hi all,

i am a complete newbie in fmp. I'm doing an internship at a company and they are using FMP 5 so as i know already it is really outdated.

they asked me to edit the current forms a bit. and now i'm a bit stuck on a search filter.

they want to exclude some fields from a search.

they have for example 2 different contact fields and they want, if i fill in a name in the first field and leave the other field empty that it excludes the empty field from the search so that all the records that are found have the contact that is filled in but in the other contact field is nothing.

and all the other fields that are not filled in should be included in the records when a search is done.

sorry for the bad explanation English is not my 1st language.

i hope someone understands what i mean if not tell me and i try to explain it better.

thanks

Jeroen

[IdealData]

You cannot 'exclude' fields from a search, however I think what you mean is you want to OMIT the empty name fields.

FM will let you perform multiple FIND requests in one session, just keep adding new find requests.

The '=' symbol is designed to allow you to search for content this is 'equal to' - so '=' on it's own will search for 'empty' content. Make this your second find request and combine it with the OMIT marker in the status panel and all should become obvious.

[joen0s]

Great!! thanks!!

just tried it and it works. sorry for the confusion about the OMIT and EXCLUDE :

but thanks alot.