Thanks for the last reply and I do understand that crystal does read through all the records but if the link was done from the info to the transaction it would be faster since there is less records in the info.

I work with SQL and the way you link your tables is critical when dealing with large amount of data.

Since the customer number is indexed this small query that I am doing should be a lot faster, shouldn't it be?

Thanks for the help
Yann