Filtering Lookup Field

[Steven_Joiner]

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?

Thanks.

[Elias_Gomez_Sai]

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