Limiting options in a section editor pull down list field

Hi All,

I'm sure that the answer is somewhere in the forum, but I couldn't find it.

I’m stuck as to how, in a section editor pull down list field, I would limit the options available to only those that matched a checkbox value of “1" or “YES” in another table.

Here’s what I’m trying to do.

A client of mine wants to be able to offer custom made training videos for students of her dance school. Access to these videos will be restricted to members who have videos.

I’m using the membership plugin, and I thought if I could:

1) create “videos available” check box in the user accounts editor, and
2) create a video section with a pull down list that only showed those users who had their "videos available" check box checked,

I wouldn’t have to scroll through a long list to assign a new video to a specific member student.

I played with the get options from database and from a MySQL query but I’m totally lost on the latter.

Any specific suggestions?


Thanks,

Jerry Kornbluth