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!