I have tried to look at some other posts but I'm having trouble relating them to my solution, so I do apologize!
I was able to set up my conditional value list thanks to philmodjunk, so now I just have one last step for this section of my solution: getting sequential numbers that restart for each record. In short, I have my Course table which, and each course is comprised of different sections that relate to the course. I would like to have a 3-digit number (i.e 001, 002, etc) that is automatically entered when a section is created for a course, but make it so that it restarts when a section is created in a different course. Basically, if I have Math 101, I can add sections 001, 002, etc., and then when I go to English 101 and add a section it will start back at 001. Each section does have a unique ID number to for relationship purposes, this new number is just to identify it sequentially within the course.
Thanks for the help! Yall are lifesavers!