Never one to be surprised to find something new after 35-years of FileMaker development, I hope someone can help with this one.
A contextual menu item I've never really taken notice of before, when in a field in Browse mode, is 'Find Matching Records'. Never having had the need to use this (has anyone?), it is creating a headache in controlling access to some data (please no lectures that we should be using record and field level security, we know this argument and will become a tangent to this question)
We need to disable this menu, but it appears to be a challenge. It appears to be embedded within the View > Find Mode standard menu and doesn't appear within the custom menu selection. Removing the standard 'Find Mode' menu and it disappears. So how to disable but still allow a user to enter find mode?
We created a single line script to enter find mode, created a custom menu, replaced the standard menu item with another, again called 'Find Mode', set command/ctrl F as the shortcut, ran our script and success!
However, now the Find button in the status bar is unavailable, everything else is working as required and no contextual menu item, along with Extend and Constrain items disappear.
Back to the custom menu: enabling the 'Based on existing command' and leaving all the 'Override default behaviours' selected. The status bar find button reappears, as do the 'Find Matching Records', Constrain and Expand contextual menu items. Back to square one!
We did script a custom menu 'Perform Find' and add an 'Omit' to the script, but again the 'Perform Find' status bar button is disabled, as are the return and enter keys.
So far, we can't find a way to independently disable this contextual menu item and would welcome any other ideas.
Many thanks
Andy