5 Replies Latest reply on May 13, 2013 7:01 AM by philmodjunk

    Adding a field that automatically counts other records

    StevenVincken

      Title

      Adding a field that automatically counts other records

      Post

           I have a table with records, each record has 4 fields:

           - recordid
           - productname
           - date
           - number

           I want to add another field to each record, called "futurenumber", that automatically contains the sum of "number" of all records with the same productname that have a date later than the current date (today).
           I'm guessing this should be a calculation field? And it's probably easy to do, but since I'm relatively new to Filemaker, I don't know how. So any suggestions are much appreciated!