There are again some options here. Firstly, the most obvious duplicates will be eliminates by checking 'No' for 'Print Repeated Values'. Also, there is GROUPing options, 'Print When' and so on. Ultimately, you can even remove duplicates from the cursor itself.
>Yes that is true Mr. Pikman. The problem is, after you union many one-to-many tables, the whole table will be combined to one big table with data duplicated. While in the report, you need to print not the whole table, but only the data you need. Is there any good method you know that can achieve this?
>
>Thanks.
>Bin
>
>
>
>>Usually, report form is based on cursor and it's up to you to manipulate data within this cursor (VFP is the best data manipulation engine) to include all
> needed data in any needed order. For example, you can UNION records from different, even seemingly distinctive tables.
> BTW, simple one-to-many situation can be resolved by standard LEFT JOIN with subsequent grouping.
Edward Pikman
Independent Consultant