Barbara,

Thanks for the insight, I appreciate the fast reply.

Thanks,

Wes ;-)

>>Hello,
>>
>>I have a report with a personal dbf related to a children dbf via a 15 character field ( cpersnlid ),
>>the one side of the report works fine, the child side many doesn't. I get either too many records,
>> some may be ghost ( blank, don't exist ), or not enough records come across. I have tried views,
>> on each of the data bases; and, am getting inconsistant results, with these also. Any ideas and,
>> sugestions greatly appreciated. I am using VFP 3.0b.
>>
>>TIA,
>>
>>Wes ;-)
>
>Wes, re-index and check the results. Inconsistent results like this frequently are caused by scrambled indexes. Then work with your views until they show the right data. Run the report from a view and you'll be home free.
>
>HTH
>Barbara