If you use relations between first table and second ( and second table has diffrent index from that is used into relations) it really should not work
I would advice dont use relations , use filter instead on the second table in the grid, or make view with parameter on the key from the first table.
In both cases you will be able to use index on the second table
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.