>>>
>>>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

Yes, you understood me right.. Thats what I want..

Thanks for your reply, I guess time to again check your article. I will try that..