4 Replies Latest reply on Feb 2, 2016 8:15 PM by denversusan2

    Performing Find based on Field Info

    denversusan2

      I have a table that stores member interests by year - one of the fields is "Membership Year".  When I create the script to show me all the members interested in "Skiing" in 2015 one of the find requests has to be for the current year (Member YR = 2015).  Which isn't a big deal but I have about 20 groups to generate lists for.  Which means at the beginning of the next year I have to go in and change all the scripts to the new year of 2016.

       

      I was hoping I could have a field called "Current Membership Year" in the table, set that to 2016, and then somehow set script to find only the records where "Membership Year" is equal to "Current Membership Year".

       

      Appreciate any suggestions.