I am hoping to use a lookup between two lists to help with a training registration process. The goal would be that we have weekly offerings of the same training course, which then would of course take place at various locations. So, therefore in List A for our schedule, the course title could appear multiple places, but the other values would be unique. Example:
System Basics, 05/18/2022 8:00 am, Training Room A
System Basics, 05/19/2022 10:00 am, Training Room B
System Basics, 05/20/2022 8:00 am, Training Room A
Advanced System User, 05/20/2022, 8:00 am, Training Room B
On List B is where I want to register the trainees. I would like to be able to lookup not just by the Course Name, but also then have my options filtered for the time and/or location when I am creating new rows/entries for List B. This way, I am not having to specify class name, date/time, and location all in the same field - if what I enter in my new row entry matches on all of those components from List A, then it can match to that row in the schedule.
Any tips on accomplishing this would be appreciated!