>Hi Everybody, happy new year!
>
>I ran into something interesting today and am intrigued by it...
>
>I need to establish a relation between tables that belong to different databases.
>
>The code looks something like this:

use dbc1!authors
>use dbc2!books in 0
>select authors
>set relation to AuthorID into books

When I run the above, and open a browse window for each table and move around in the parent, the child's browse updates correctly, showing only records that are children of the record selected in the parent table.
>
>However, if I do the following in the command window, it doesn't work:

select authors
>goto 5
>? books.eof() && This one yields .t. - it's as if the record pointer stays at eof() in the child area.

>
>Any ideas?
>
>Thanks!

Sure ?
exists fkey for the record 5 ?