Hi, Edgar!

First of all, try to avoid using the reserved words as the field names

USE your_table_name IN 0 ALIAS PARENTS
USE your_table_name AGAIN IN 0 ALIAS CHILDS
* select all childs from top record
GO TOP
SELECT Tname FROM CHILDS INTO CURSOR cRelations WHERE childs.pid=parents.id
BROWSE nowait