>The second parameter is the CDX file name, not the alias of the table
>
>try
>
>

>use myTable alias myAliasName in 0
>? Sys(14, TagNo('myKeyName', Forceext(Dbf('myAliasName'), 'CDX'), 'myAliasName'))
>

Thanks again. KEY function seems to work, so I used it.

Anyway, now two new questions.

1. Do you see a problem with this statement

SELECT TRANSFORM(&lcExprC) as ChildField, ;
     lcParent as Parent_T, lcChild as Child_T, ;
     lcExprP as Parent_E, lcExprC as Child_E ;
     FROM (lcParent) ParentP ;
     RIGHT JOIN (lcChild) Child ON ;
     ParentP.&lcExprP = Child.&lcExprC ;
     WHERE (ParentP.&lcExprP) IS NULL INTO CURSOR curOr nofilter

Looks like it selecting a lot of records, while I would expect to have just few orphans.

Also I'm doing these selects in a loop. Is there a way to gracefully interrupt it?

Thanks again.