>>
>>With your present structure, you have no way to determine which address goes with which contact, so you get all 4 combinations when you have 2 addresses and 2 contacts.
>>
>>Christian
>
>Thanks for your answer... But I don't want to link phone nos. with address. It is like that there are 2 phone nos. of person and 2 address..
>
>Isn't there any way to get it..
>
>As similar kind of structure, I'm having in my other projects also, where one master is linked with 3-4 childs, but no child is linked with each other..
>
>Pls give your suggestions....

I think I understand now (maybe ?)

you want a report like this : NAME CONTACTS ADDRESSES

Name Contact1 Address1
Contact2 Address2

contact1 and address1 are not related, same for contact2 and address2

then you have a typical example of parent table with two child tables report, such as the one described in one of my articles on SQL select. Is this what you want or did I misunderstand once again ?

If it is, then you need to do a query with a UNION : first part on names & contacts, second part on names and addresses, using space holders to fill in the gap and make the two parts compatible.

the resulting query will have the 4 records, but in the report detail band, you will use two superposed sets of fields, one for contacts, one for addresses, using PRINT WHEN clause to only print what is needed.

Christian