Describe Field Current Membership Year as Global
Fill the Field
Allow user abort off
Set error capture on
Set varible $YR to Current Membership Year
Enter Find mode
Set Field Membership Year to $YR
If Get (found count) = 0
Display Custom dialog "No record found"
I'm not sure what your structure looks like but it sounds to me that you may benefit from something like this:
MEMBER---------< INTERSET >--------- ACTIVITY
Where Member records would be:
And Activity records would be
And Interest records would be
You could then pull reports that answer question like:
1. What was the most popular activity in 2012?
2. Who was the most active member in 2014?
3. Who is the all-time most active member?
4. Who is interested in Skiing this year?
Thank you! Worked perfectly!
Thank you for the suggestion - will try this as well!