>I have 3 tables
>
>name having names of persons
>address having addresses of persons
>contact having contact nos. of persons
>
>name is parent which is related with address by code & it is also related with contact by code.
>
>Its one parent and 2 childs.
>
>I want simply a report like this :-
>
>name contact1 address1
>name contact2 address2
>
>I have one record in name, 2 in contact and 2 in address, the right result should come as 2 records
>
>instead it is giving me four records, contact nos. and address are getting repeated.
>
>This prob. I have already asked here when I was doing this thing through SQL & was not able to get the solution. So, I tried FoxFire and .... Result is same..


AFAIK, I don't think this a problem of the report tool but rather that your SQL statement omits something. When using multiple tables in a SELECT statement you must be careful to specify the needed filters in the WHEN clause. Otherwise you'll get a cross product of every records of every tables.


Claude.