Ok, ive finally got somewhere, i have made the KeyRelation blank, switched
KeyLinksAutoDefine to true and put KEY_NO in the KeyLinks strings.

It is now i'm glad to say not bringing all the records to the client as a
client recordcount takes a while and the selection of a set of data is
almost instant.

It was defianltely the keylinks, this would explain why my other app works
fine. In IBO3 for Delphi 4 I didnt have any keylinks in an IBOQuery.

I've still got some final testing to do, but it looks like its sorted.

Thanks very much :-)