Min Summary Field

[Leader]

I imported a FM3/4 DB into FM 8.2 and I've hit a snag. The file has a Summary field with the Min function, and it returns the lowest integer just the very first time, but does not update even as records with lower values are entered. This holds true whether the Summary field is in the footer or the body.

I have to believe this worked in FM3/4, but I'm baffled why the field isn't updating in FM8. I've also tried Max and Average functions with similar results.

I'm out of bright ideas what I might be doing wrong. Help!

[Genx]

tried refreshing the window?

[VICH]

or a commit step?

[Leader]

Hmm… No scripts are involved, so no to both questions. When I leave that layout or even the file and return to it, the 'bad' result is still there, the value that never seems to update.

[T-Square]

Is the field calculation stored?

[Leader]

Ah! Good question. It was a calc field with a relational reference. It doesn't show unstored, but apparently the older FM3/4 allowed the relatiional reference to work and FM8 doesn't.

Thanks.

[Vaughan]

Summary and calculation fields shound not be imported into the new database. Instead, recreate the summary and calculation fields in the new tables.

In your case you will have to also recreate the relational structure in FMP 8 that matches the old structure.