Exclude display of records

BlueGene

Hello,

anyone got an idea on how to filter records for display in form overviews without loosing too much performance?

The background: We have about 1100 customers which are closed, a filed indicating that is in the table 18.
What we don't want is to delete the customers because of reporting reasons for history.

I have thought of using securityfilters or checking on the form if the record should be displayed or not.

But this might take a lot of performance on the system. Besides, we use SQL.

anyone got the same problem and solved it any other way?

Best regards

Bluegene

GLE

BlueGene wrote:

Hello,

anyone got an idea on how to filter records for display in form overviews without loosing too much performance?

The background: We have about 1100 customers which are closed, a filed indicating that is in the table 18.
What we don't want is to delete the customers because of reporting reasons for history.

I have thought of using securityfilters or checking on the form if the record should be displayed or not.

But this might take a lot of performance on the system. Besides, we use SQL.

anyone got the same problem and solved it any other way?

Best regards

Bluegene

Hi, have you tried to create a new key for the customer table?

Create a new one with
Closed Yes / No
Customer No.

In the Customer List -> use this key an filter to all open customer.
It should work fast.

regards
Jürgen