Complex dropdown input help need

I need help to create a Dropdown Input of just the “Current Courses” under User.

Let’s say I have this database:
Grade Course Current
11 Math Yes
9 English No
10 French Yes

How can I configure the Dropdown that only displays the current courses (i.e. Current = Yes)?

Help would be much appreciated.


:filtered current is “yes”

so smart! thank you!!