Cristal reporting with proper way

I have 2 tables named Purchase and Sales and the tables field name is

ProductID ProductName Quantity

when i am opening this table from cristal report it's creating a link wiht the ProductID field. I have only 5 rows in both tables but in the report it's showing a lot of rows.

What can i do will you please tell me wha's the proper way to make a report and make a quary? Is there any tutorial for learning cristal report?

Will you please help me?

Thanking you
Rummy

What do you have the productID linked to? Are there more than 5 matches?

Do both tables have the same exact field names? CR will try to make "Intelligent" joins on tables. This means that if two tables are added to the report and if they both have a numeric field with the same name, CR will "Assume" that they should be joined together.

Could you post a of each table's schema as well as sample data from each table?