Subject Re: [IBO] How to avoid lookup table from fetching all records ?
Author Harald Klomann
> They are false already. If I set KeySeeking to False It doesn't fetch the
> records, and the lookup doesn't work too...
> Thanks in advance


are you shure, that all records of the lookup dataset are fetched ?
Normally, by opening the main dataset, a bunch of records are fetched
from the server, depending on your settings. For each of this records,
there will be a fetch to the lookup table - but only, if the record
to be fetched doesn´t exist in the buffer. So please check, how many
records exist in your lookup table and how many of the are fetched
after opening the main dataset.