Calculate Next Upcoming Date based on related records
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.