>>>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.

If you also use an index to decide what child records to show, then there is a conflict. If this is the case, you are better off if you use a parameterized view for the child records. Then you would have no trouble in creating temporary indices - which would, by the way, be created much faster, for you are only indexing the records that are shown.