AnsweredAssumed Answered

Restarting Numbering Sequence, Drop Down Functionality

Question asked by bleyden on Feb 19, 2018
Latest reply on Feb 19, 2018 by bleyden

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!

Outcomes