I have a strange problem involving a couple of grids in a form.

The two grids display related information from two different related tables.

The main table, indexed on No and Index fields, has records like:
No-Index
2010195-01
2010195-02
2010195-03

The two related tables each contain a number of records related to each record in the main table, like:
No-Indes-Other info
2010195-01-aaaa
2010195-01-bbbbbb
2010195-02-aaaa
2010195-02-bbbbbbbb
2010195-02-ggggg
2010195-03-qqq
2010195-03-ttttt
2010195-03-uuuuuuu

If the form first is positioned on the -02 index, everything looks fine, both grids show the corresponding -02 records. Somewhere else in my form (another page in the same PageFrame), the relations (from other tables) move the position in th main table to -01 and, consequently, also in the related tables, but I have a property in the form that holds the "active" index, that (in the activate event of the page that holds the grids) is used to reposition the main table and the related tables to the -02 index. I can see in the debugger, (and with wait window commands) that the tables have been moved to the -02 indexes, I have also other controls in the page, bound to fields in one of the related tables, that are refreshed and displaying values from the correct record of the related table. I also call Refresh() on the grids. Nevertheless, the grids both show records from the -01 index. I also know, that it is not because the grids are in some way manipulated elsewhere in the form, because I have tried adding a third grid with the same properties, and that grid acts the same way. I have checked order, relations, set exact/near, I have tried with indexes based on no+index and indexes based on no+index+something else, same result...

Anybody got any ideas? Am I missing something?