This question is a tangent from a previous post but since it's different in the goal I decided a new post would be best.
Tables involved: Enrollment, Courses, Sessions
I have course 30001. As part of a portal, this layout shows "Sessions" that are associated with this course. Is there a way that I can have a field as part of each Session that will list a number (i.e. 001) that will continue to increment as each new session for that course is added, but if a new course (30002) is created the session number would start back at 001?
Secondly, in my Enrollment form, I have a dropdown which will show me the courses in the system. I have another dropdown for Sessions, but I am having trouble getting it so that it shows sessions that are associated with a specific course. Sessions do have a unique field (timestamp).
If any more details are needed please let me know!