Hello,

I'm using a form to browse and update a table with the
fields: organisation, customer, ...

On the form only records of one organisation should be
displayed. The user is able to select the organisation
with a command button. I have set a filter like this:
organisation = '001'

I have also an index on organisation to optimize the filter.
But it is still very slow:

e.g. Organisation '001' 150000 records
Organisation '002' 250 records

It seems that in the case of organisation '002' all records
were read -> takes 70 seconds to move from the first to the
last record.

Without a filter it is quite fast.

Any suggestions?

Thanks in advance.

Andreas