>I have 2 tables :-
>
>1. Name :- which is having 4 fields :-
>
>code, name, age, male
>
>2. Contact :- Which is having 2 Fields
>Code, Phone
>
>I am using following code :-
>
>AllFields="name.name,name.age,name.male,contact.phone"
>Set fields to &AllFields
>copy to array MyArray
>
>There are 3 records in Name & 4 records in phone:-
>
>It is giving me in array the associated record in contact for first 2 records, but for the 3rd record it is showing me all .f. values
>
>Can Anybody Tell me, what's wrong ???
Are there 3 records in table 2? I would do this with an outer join to a cursor and then copy to array from the cursor, or just use the cursor directly (even better).
HTH