Question Why?

[maks_prince]

Why am i getting 26 duplicate records being displayed in my report. While i just have 2 records. These 2 records are shown 13 times hence making it to be 26 record. What is reason for this duplication? Any solution!!!

 

[DCrake]

Do a search on Cartesian Product

 

[maks_prince]

I don't get you... I just have no idea about what you told me to search... I am still a beginner in programming... Is there a simple expalnation...

 

[DCrake]

You have to tables which have been joined using a common field. one table has 2 records that match and the other table has 13, therefore 2x13 = 26. For every record in table 1 it is being displaed for every record in table 2

 

[Brianwarnock]

You have to tables which have been joined using a common field. one table has 2 records that match and the other table has 13, therefore 2x13 = 26. For every record in table 1 it is being displaed for every record in table 2

This is a best guess since there is little information from the original poster, not an unusual occurence these days, the query on which the table is based might prove useful.

Brian

 

[maks_prince]

Its not what you are guessing... Yah there is one to many relationship between the two tables... And each table have an equal number of records...