Dynamic Scripted Finding

[Mike_B.]

I'm in a bind and can't figure out how to proceed.

I need to script the finding of records with both a "find" and "omit" request that are based on variables. As far as I can tell, there's no "toggle omit checkbox" script step. I can't use "constrain found set" due to requirement to use variables.

Basically, I have:

$thisyear

$lastyear

and am trying to find where Year=$thisyear AND Year=/=$lastyear (the year field is in a linked table holding dues records, one to many - person to dues keyfield relationship)

I am using the

-enter find mode

-set fields

-perform find

format.

Please help! Thank you all in advance!

[comment]

See if this helps:

http://www.fmforums.com/forum/showtopic.php?tid/202630/

[Mike_B.]

I can't believe I've been missing something so easy all along!

I never knew that "omit record" step was available in find mode.

Works for me, thank you!