Can you filter a value list?

[JTSmith]

I have a table called Clients. This has all the clients information and a field called Active. This field is Yes or No. On a different table, Jobs, I have a drop down for a list of the Clients (the name field to be specific). I'd like to only show the ones that are Active. Is that possible?

Thanks!

[xtrim]

Yes.

you can do a calc field "Active_Client" in Clients:

If ( Active="yes" ; Client_Name )

use this new field for the value list.