How can I transfer summary data from one table to the other ?
Consider layout LA, using table TA with fields DateAsFirstOfTheMonth and DateOfOccurrence. I have created in layout LA a summary of count by DateAsFirstOfTheMonth. Consider table TS that collects statistics and is "unrelated" to table TA. Table TS contains the fields TS-DateAsFirstOfTheMonth and CountOfOccurrence. How can I populate table TS with the summary data from table TA ? I had thought of using getsummary in the field definition of CountOfOccurrence, it just doesn't work. Am I doing something wrong ? Is there any other way of populating TS from TA ?
BTW, populating the data should take place in real time.