Hi Cetin,

But there IS a matching record in books for author recno 5.

Like I said, if I open a browse window for each table, and select authors' record #5, the browse table for books shows me the books written by this author.

If, on the other hand, I close the browse windows and go to the command table, then navigate to recno 5 (goto 5), and then I do "? eof("Authors")", I get .t., which would indicate (erroneously) that author #5 has not match in the books table.

Alex


>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