Hi Alvison,

Thanks for the reply. I'm not sure what you mean though, are you referring to VFP or Crystal Reports in your reply. I know how to code SQL in VFP, the problem I'm having is with Crystal Reports.

Regards,
Gavin.

>use the INNER JOIN clause for SQL; that will do the Job man! dont forget to link the common fields between tables, and their relationship as well!