>Main Table
>-----------
>Abone : 715.317 records (Abone table has index on ekler and hurun fields)
>
>
>Child Tables
>-----------------------
>Hurun : 20 records (Hurun table has index on id field)
>Ekler : 16 records (Ekler table has index on id field)
>
>
>All the fields (abone.hurun, abone.ekler, ekler.id and hurun.id) are int type and indexed
>Index collate ise turkish and alt tables has türkish code page. && cpdbf("abone") returns 1254

What happens if you add an index tag on exp in the tables that have that field?

Tamar