>>>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.
>
>Enforce the directory to work efficiently.
>
>USE first_dir\table1 IN alias1
>USE second_dir\table1 IN alias2
>
>SELECT alias1
>blah...blah...blah...
>SELECT alias2
>blah...blah...blah...
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."