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.
Bin Li
Software Programmer
VGI Vision Group International, Inc
Tel:(250)658-6321