Robin,

Yes

You might adress

*open
OPEN DATABASE first.dbc
OPEN DATABASE second.dbc
*activate first
SET DATABASE TO first

*use will respect acitve dbc

USE somedbf ALIAS FIRST_DBF

*use in specific dbc (first is active)

USE second!somedbf ALIAS Second_DBF

*in sql select / insert update

SELECT Cur1.Field1 F_First,Cur2.Field1 F_second  FROM First!somedbf AS Cur1 INNER JOIN Second!somedbf AS Cur2 ON someexpression

*XBase like append etc will respect the local alias

*close a specific on
SET DATABASE TO first
CLOSE DATABASES

If first and second differ only in path, you have to specify the path all the time.

HTH
Agnes
>Hi

>
>I have two seperate applications with two databases.
>
>I've used wide field names for my tables in both, if I want to append records from one table in one of the databases to another table in the other database, and the structures are the same, will it transfer ok.
>
>I'm just concerned that sometimes when a table goes "outside the database" , all the extended features of the table are lost for example file names get truncated.
>
>Can I open the two databases at once?
>
>TAI