A sophisticated one this, so I shall attempt to clarify greatest I can.
The top results of all this can be a web page the place the person picks an exercise from a drop down (or nonetheless greatest to show the choices). It then exhibits one other checklist of all programs inside that exercise. Lastly once they choose the one they need, it is going to present particulars of the individual working that course. Nonetheless to complicate issues, the identical individual might be a coach on a number of programs.
I’ve made some lists to organize, one for the trainers, one for all of the programs and one for the checklist of actions. However maybe I’m going about this mistaken.
What’s one of the simplest ways to attain what I’m after?
I assumed I might use lookup columns however my thoughts has simply gone clean on the place to start out or even when what I would like it attainable. I even considered utilizing Infopath in some capability.