Radio buttons to affect value list

[LoganSDA]

Hello,

I represent a company called Sutherland Design Agency and I am creating my first database with file maker. My CEO wants me to set up a drop-down menu on our time cards that lists all the open projects. I created another table that has project name and a radio button set with status: open, closed. I want to be able to filter the project name field in a value list so that if a project is closed it doesn't show up in the drop-down menu on our time cards.

My boss says this is definitely possible, but i'm not sure how to do it. I'm a total beginner. Any help would be appreciated.

Thank you,

Logan