Adding a field that automatically counts other records
I have a table with records, each record has 4 fields:
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!