You're a Genius, thank you so much works perfectly. I will analyze it and learn, Thanks for the Help oh mighty one.

Thanks

Paul

Thanks, I will try it....now

Ignore the Paym, Int part of the record it has no significance, I just need the last record entered from the child table.

Yes the 9/31/2007 should be 09/31/2007.

The Tie breaker would be the last record entered for that Polno.

When I set a relation from Master into Transaction file on Polno

and the Transaction...

Thanks for the question, I know I haven't explained it very well.

Here goes,

The Transaction file is Indexed on Polnumb+dtos(transdate) descending

So I want the last record entered in my temporary cursor...

I didn't preview the post and have since tried to fix the format of the question and how the data should look. I hope it is earier to read