AnsweredAssumed Answered

constraining find with variable

Question asked by jayGamel on Jul 20, 2012
Latest reply on Jul 20, 2012 by philmodjunk


constraining find with variable


I've tried a hundred ways of doing this but nothing works. FMP11/mac Intel>


I have two compound finds: active and ongoing, active and fifteenth(or first). From this found set, I wish to omit any record that already has a specific issue number (which changes every 15 days). I have a current issue calculation that works fine. If I set up finds using the actual current issue number, no problem. I can't set it up to use a global variable already set to the current issue number ($$ci)


Here's a screen shot of what works


How can i make it work with the variable instead of the actual issue number?


Thanks for any help.