Skip to main content

Filtering Lookup Field

  • April 2, 2018
  • 1 reply
  • 7 views

Forum|alt.badge.img

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.

This topic has been closed for replies.

1 reply

Forum|alt.badge.img+17

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