AnsweredAssumed Answered

Calculate Next Upcoming Date based on related records

Question asked by BridgetRoell on Jun 23, 2013
Latest reply on Jun 25, 2013 by philmodjunk

Title

Calculate Next Upcoming Date based on related records

Post

     I have two tables: one with a list of Class types and another with a list of Class instances that are related to a specific class type. For example, "Adult Pottery" might be a class type with class instances on 6/22, 6/29, 7/6, etc.

     I would like the Class Type record (in this case Adult Pottery) to have a field called Next Class that would look at the related Class Instances and calculate the date of the next class (i.e. 6/29, if i were looking at it today).

     I'm not quite sure how to do this (non of my attempts thus far have worked), or if it's even possible, so any feedback/suggestions would be greatly appreciated.

Outcomes