I want to update a field that changes based on another field.
I have a student entry date field and I want to schedule his quarterly review every 3 months. This is easy to do with a second calculated field.
The problem I am having is to automatically schedule the next quarterly review for the next period.
For example, if the student entry date field is 3/5/2012(This date does not change), then the first quarterly review field should be 6/5/2012. When the date 6/5/2012 comes around the quarterly review field should then be set to 9/5/2012. And ongoing....
Any ideas on how to make this work?