Then I think there is no matching record in books for author recno 5.
Cetin

>Hi Cetin!
>
>There's no eof() method. Sorry for the confusion (sometimes I still think in Clipper, which is a bit more "oopish" in aliasing expresions.
>
>What I meant is that if I navigate programmatically to a record in the parent table, when I check eof() condition for the child (? eof( "books")), I get .T..
>
>When I navigate the parent table through a browse window (by clicking on a record), the browse window for the child table shows the right children (no eof() there).
>
>Alex
>
>
>>>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!
>>
>>Alex,
>>What is the code in eof() method?
>>Cetin