>Hello,
>
>I've just started using VFP 6.0 and run into a problem :
>
>I desperately want to make a small report on 18 tables, all with different structures.
>The user can select as many tables as he/she wants (upto 18) in a Form and then the program will make a report out of the selected tables. The report will show data from 2 or 3 fields from each selected table.
>
>The problem is:
>How can I get the data from the selected tables into one table which I can use for the report?
>
>Could you please give me some code and a simple answer, since I'm a novice VFP user.
>
>Thank you very much for your time and answer in advance.....

Try using you query builder. You will not be able to select all 18 dbfs, but just pick one or two. After getting it set up take a look at the SQL that the builder generates. Should point you in the right directions.

Select table1.field1,table2.field1,table3.field1... from table1,table2,table3 where whatever into cursor temp

This example does not show joins and is just an example.

HTH
Jeff