Hello,

I have - a series of join files for interrelated databases (using FM
5.5).

Here's the situation. One of the fields is an 'average' which averages
all the occurences that meet a certain criteria (specifically, the
person's name and the game name).

Consequently, all the occurences for that criteria have the same data
in that field.

For example, if we were playing Monopoly, and we were checking the % of
time Bob won the game, and he played 4 games and won one, then, each of
the 4 instances in the join file that show Bob PLAYING Monopoly, would
show Bob's win percentage as 25%.

OK - now, let's say Bob plays again, and loses. His new entry in the
join file shows his win percentage as 20%. And, in fact, all FIVE
entries show 20%.

However, the 'modification date' on those other entries does NOT change
to show this new calculation result...

Is there any way to track when a change, such as this, is made to a
record?

Thanks!

Chris

Lemur wrote:
Interesting and well-worded question.

It seems to me that what you are really looking for is the latest date
that any of the found set were modified.

So if you have a dModifiedDate field that is set to auto enter the
modify date, you should be able to set up a summary field using the
Max() option on that field, and then you will always have the latest
(max) date that any of the records in the found set were modified.

one more note. If you are using relationships to get this summary data,
use a CALCULATED field and the MAX() function to get the maximum, or
latest date from the matching related record set (rather than using a
summary field type as I indicated above).

I couldn't tell if you were using a relationship, or a found set of
records, but either way, you can make it work.