Limit Autofilter Lookup results
I have a
Current_Tasks view which has an Autofilter for the lookup field
Customer in the
Clients form. The dropdown list for
Customer is getting very long, however, because the autofilter lookup returns every single customer we have ever had in
Clients.
I have tried adding to the criteria for the Current_Tasks view Customer.Inactive ==false, but that does not affect the autofilter. I have added the Inactive == false to the criteria for the Lookup field on the Tasks form, and this does correctly limit the choices when adding a new task, but it does not affect the autofilter in the view.
Is there any way to limit the choices in the autofilter to only active customers?