Help

Filtering Lookup Field

1587 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Steven_Joiner
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Reply 1

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