Chad-

Which table are you changing the index order in? The parent or the child? Do you have the parent or child selected with the relationship *seems* to break?
Do you know that the relationship will only be active from the parent table.

BTW, you should tell us which version of FP you're using.

HTH

>I have a form with a one to many relationship. I noticed that i can't change the index order unless the PrivateDataSession is .t.
>
>If datasession is not private and I change the index order with set order to, the one-to-many relationship breaks. Works fine with a private datasession. Does anyone know if this is by design or a bug???