I am confused with a search in database, I have a indexed field with the membership status: Member and Non Member, the field is a dropdown menu when I made search usin the menu and select Members appears all records containing member and non members, if I made non members only found those correctly.

There's something I can do to correct the text input in the field, to using the dropdown menu can only find the members or need to use a function or script.

By the way I know if use ==members will found only this word, but I want using the dropdown menu option

Thanks

Karl

Hi

add to that field a script trigger OnObjectExit and enable it ONLY in Find Mode.

The script will have only to add those == to that field with something like:

Set Field [ YourField ; "==" & YourField ]

Thank you for your help. I got the script working and find the right records.

May I suggest that you consider just have a field, "flag_Member" which is a number field that equals 1 if the person is a member.

Then, format that field to be a checkbox, using a custom value list that simply contains "1".

This avoids the need for == in find, and will let you create a relationship where Constant 1 = flag_Member.