>Hi
>
>What is the best way to merge the structures of 2 tables and what happens when fields on both tables have the same field name?
>

One possibility is to use SQL SELECT to combine the results into one table or cursor. If fields have the same names, the SQL engine deals with it (or you can explicitly rename them).

Tamar