Filtering Lookup Field


I have a client table. The table is linked to another table that shows projects associated with that client. Projects can be Active or Not Active.

How do I create a field that will only list Active projects in a field on the client table?



You have to check that in the Projects table, Grouping By client for instance, and adding a Filter to view only Active projects.