Hi Neil,

'Select user, database, type, date, time'+;
' from ("U:\Logs\310703\pdmlog.dbf") where temp.mainkey=pdmlog.mainkey

This is incomplete, temp.mainkey is fixed.

- RECCOUNT('pdmlog') = 3.000.000 ?

- mainkey is a PrimaryKey C(?)

1) How much is the Max possible value for RECCOUNT('temp') ?

2) U:\Logs\310703\pdmlog.dbf have a index on mainkey ?

3) U:\Logs\310703\pdmlog.dbf is hard ordered on mainkey ?

If you answer, i can found the best solution.

A first solution is:

SELECT Temp
INDEX ON mainkey TAG IX_Sel

put this query on grid RecordSource:
'Select user, database, type, date, time'+;
' from ("U:\Logs\310703\pdmlog.dbf") WHERE KEYMATCH(mainkey,1,'Temp') into cursor temp'

Fabio