>I need to insert records from one table to another, the tables have the same name, so the database, but they are in diferent directories.
>
>I open the first table and wend i try to open the second it always find the first table .
>
>What can I do to resolve this situation ?
>
>
>Thanks
>Carla
I would recommend opening ALL tables with ALIAS then referring to the alias.
USE table1 IN 0 ALIAS FileOne
USE table2 IN 0 ALIAS FileTwo
You can then open as many tables as you like with the same name. Personally, I even include alias when it is the same as the table name - to force the habit.