I have aproblem in cristal report 4.6.1 whin I use more than table in the same repor

[MANNO]

Hi all ....
I am using VB6 and Access database
I created a report by cristal report 4.6.1 and added 3 tables in the report (quary tables) the problem is it doesnt show the rght data in the 3 tables
but shows the rght data at 1 of thiem and 1 record from the others and dublicate it on all records that show
For more explane see the attachment ....
In the attachment I added 2 tables only and the prblem still on
u will se the "Sold Stuff" is Good but the "Came Stuff" is no good
hope u can help me ...
thx in advance .

[shakti5385]

If you are using more then one table in the report then be sure that all are properly linked , so then it will work fine.
You have to check all the linked in the table that you are using in the report