AnsweredAssumed Answered

constraining find with variable

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

Title

constraining find with variable

Post

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.

Screen_shot_2012-07-20_at_11.28.28_AM.png

Outcomes