Hi,
We have a custom table, and it shows the active records of the table. In that view there is a lookup column which is related to another custom table that has both active and
inactive records.
When we use filter by option for that lookup column, it is showing both active and inactive records. For example, When I search for a record (which contains duplicate also) it shows both active and inactive related to that.
The requirement is it should only display the active record related to that search. Is there any possible way to display just active records in the filter by option.
I have attached the screenshot for reference.
Note: I have also tried using edit filter option but no luck.

Thanks in advance.

Report
All responses (
Answers (