Filtering Lookup Field


#1

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.


#2

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