Thx Guys
>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
Rob