Hello, I have the following sql inside of a calculation field. The function works correctly, but it does not refresh the data when records are added or changed. For instance this field calculates how many active members there are. When I remove or add members the result does not update.
I've tried refreshing the field, but the only thing that seems to update it is to open the manage>database window. I'm running filemaker 13.
|SQL = ExecuteSQL ("SELECT SUM (\"Member Count\") FROM Memberships WHERE \"StatusExpiry\" = 'Active' " ; "" ; "")] ;|