I recently upgraded this database from FMP6 to FM8 and am having the calculation not work as it did originally in FMP6.

1. I have a summary field Record_Count in table ECal that gives the total of records in the Found Set. Record_Count appears in the footer of the layout in list view.

2. I am trying to get the value of this field from another table Schedule to see how many records I need to manipulate in total.

3. I have a relationship between the two being ECal::Serial_Number = Schedule::Serial_Number_Temp and the relationship is named ECal_Serial

I use the calculation: GetSummary( ECal_Serial::Record_Count; ECal_Serial::Record_Count ). It used to return the value "135" but now it is only returning the number "1" instead of the actual Record_Count value (135).

I think it is pulling the Record_Count value from the first record since that record would be record #1 in the total count. What am I doing wrong? Has the GetSummary() command changed that much since FM6?

Thanks!

Edited August 3, 200619 yr by Guest
Might be important if I clarify what Record_Count does and what I am trying to manipulate with it, huh?

Check that indexing is switched on for the key fields in the relationship. I did a conversion that failed to retain the indexing parameters, thus relationships didn't work correctly.