Peter,
Sorry about the delays answering... I'm only on UT intermittently this week. If your order is incorrect in the Form INIT then it is being switched in the LOAD or in the INIT of one of your controls. You can put an ASSERT .F. or SET STEP ON to open the debugger in the LOAD code. Try resetting the order in the form INIT and see what happens. That may be all you need.

Also, set a break point at the point where the order changes if you want.

If you change an index structure all the records presently in the table will be reordered according to the new structure, so if you change from datefield order to dtos(datefield) it will reorder. The main reason for using dtos(datefield) is so you can link other character fields into the index (or, of course, str(numericfield) ).

HTH
Barbara

>Barbara
>
>Ok, I was able to get to the debugger (with a SET STEP ON in the form INIT) and set a watch for ORDER()... It's NOT showing the right index. What controls the index on the form when you have multiple cursors (files)?
>
>I know it's not the DB controls because I did a set order in the DE on another form and that one is right.
>
>Second question regards the index itself, it is a date field. For some reason, I don't know if I read it somewhere or not, but in the DB for the index on the date field I had DTOS(logdate). Is that right or wrong for indexes on dates? If I change it, does it rebuild those indexes for the records in the file currently?
>
>Thanks