>>>I have a Form in which Data Environment has two tables Parent and Child.
>>>They are in parent-child relation.
>>>
>>>In Form there are controls (textboxes and grid) for showing values of Child fields.
>>>
>>>When I do INDEX ON childfield command for table Child and after that do thisform.refresh() all values in textboxes and grid are blank, they disapear.
>>>But when I look in data session all values are in tables like they were before INDEX command.
>>>
>>>I am not sure if this is a bug or what, but it's a problem for me, I can't solve it.
>>>
>>>Help anyone?
>>
>>Boban
>>
>>Why do you do the index if they are already on the form, in the DE, in parent-child relationship? The movement of the file pointer in the parent table should automaticall fetch the child recs for the parent, in the grid.
>>
>>Terry
>
>Because of sorting for display purposes.

Build all the indexes you need first. Then use SET ORDER to switch. The SET RELATION again.