>Fabio,
>
>This select is quite slow. Do you know if it is possible to make it quicker?
>

>select curTemp.cTrans_pk, TI.cInsurances_fk ;	
>		from curTemp inner join Trans_Insurances TI ;
>		on curTemp.cTrans_pk = TI.cTrans_fk ;	
>		where TI.iSequence_Number = (select max(iSequence_Number) ;
>		from Trans_Insurances X ;
>		where X.cTrans_fk = TI.cTrans_fk) ;
>		into cursor curTemp1

with VFP it is hard

before posting 10 solutions,
you could furnish me these information:

- reccounT(curTemp)/reccount(Trans_Insurances) ratio
- is curTemp.cTrans_pk a pk
- is TI.cTrans_fk a pk or for every curTemp.cTrans_pk the join has many TI.cTrans_fk