>OK, i hava a couple of free tables in a master - child relationship. If i type from the command line (both tables opened):
>
>SELECT ChildTable
>SET ORDER TO RelationIndex
>SET KEY TO ParentTable.RelationField
>GO TOP
>BROW
>
>Every thing works fine. But i have a form with this 2 tables (among others) added and if i run the same code i get the error "Table is not ordered" when the GO TOP is issued. Even more weird, cheking the table visually it seems like been ordered (the little arrow is shown), but if i try to browse it, i got an:" INDEX internal consistency error", and VFP (3.0) fully closes itself (i have tryied reindexing).
>
>Does anyone have any ideas about this strange behavior ?, it seems to be related to the SET KEY command.
J. Luis
Double check your forms' dataenvironment. Sometimes things are hidden and not easy to find. Or in code an event may happen to changes indexes. This is one problem with Inheritence. Sometimes you must look through multiple levels of code to find a problem.
HTH,
Tom