Missing field create bad side effect.

[Ocean West]

While modifying a solution, I discovered a bug that I couldn't chase down I had a relationship between two files via a constant field (iOne) for some reason the parent file couldn't reliably calculate Sum(FileB::iOne) I would have to click in to the field on the layout.

I figured out that in the relationship there was a "sort" setup and the field used for the sort no longer existed. This prevented the field from correctly calculating & displaying.

It would be nice if I delete a field that it would turn remove it from the sort list in a relationship and if it were the only field in the sort to uncheck the sort option.

[Vaughan]

Yes <nods> that hs caught me a couple of times. I spent a day working it out.

I think I posted my discovery to the Forum.