>select transaction.*,customer.name ;
>From Transaction, Customer ;
>where transaction.customer = customer.code ;
>order by transaction.customer,transaction.date
From the looks of this statement, your result should be in ascending order by transaction.customer (or customer.code). Is this what you are seeing?
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos