found set and constrain found set confusion
I am trying to program a data picker window which filters a simple list from a table and omit one or more specific record.
Unfortunately I am not successful to formulate a script that achieve what I did in SQL.
I actually formulated it with RAZOR-SQL against my Filemaker DB and it delivers exactly what I request):
In Filemaker I can do the parts, but I cannot bring it altogether:
Enter Find Mode
set field __kp_kotoNr 8000
enter find mode
set field __kp_kontoNr:*0*
I appreciate any help. Thanks
(It is a pity that we cannot fire SQL Statements against the own FM file to retrieve a found set - maybe I missed something :-( )