Calculations not working consistently

[coreyw]

We have a very complex group of databases that seems to be experiencing some weird problems. We have one calculation field that is the sum of several fields but it doesn't always do the calculation. If we search for records that contain data in one of the other fields there should be a subtotal in the "bad " field. What is strange is that sometimes it does not do the subtotal until you browse another record and then come back.

This same subtotal is included on a sales summary and in the summary it does add up our totals right.

Basically there are some inconsisitencies in one or two of our calculation fields and we can't figure out why, other than possibly database damage. What procedures can I perform to fix things?

One thing we are going to try, as per Filemaker support, is save a compressed copy. We have about 80 related databases, the largest of which contains 63,000 records with around 250 fields.

Any suggestions would be appreciated.

Let me know if you need more information.

[Vaughan]

I had a similar problem. The relationship was defined to sort the records, but the the sort order included an invalid field (it had been deleted or something). Removing this bad field from the sort order fixed it.

[coreyw]

Thanks for the tip. We are pretty sure that a relationship has gone bad between 2 of the databases. We deleted and redefined them and it appears to be working.