1 2 Previous Next 20 Replies Latest reply on Jul 22, 2011 10:33 AM by BarryFass-Holmes

    "Counting the Number of Unique Values in a Field" OK in FMP Windows, not in FMP Mac

    BarryFass-Holmes

      Summary

      "Counting the Number of Unique Values in a Field" OK in FMP Windows, not in FMP Mac

      Product

      FileMaker Pro

      Version

      Advanced 11.0v.2, Client 11.0v.2, Advanced 9.0v3 (Mac); Advanced 10.0v3 (Windows)

      Operating system version

      Snow Leopard.7; Windows XP

      Description of the issue

      The method for displaying the number of unique records in a field (http://help.filemaker.com/app/answers/detail/a_id/3423/~/counting-the-number-of-unique-values-in-a-field) using a summary field works properly (i.e., displays the correct number of unique records) on FMP 10.0v3 Advanced running under Windows XP, but does not under various FMP versions under Snow Leopard; the field does not display a value at all.

      However, under Snow Leopard, if I open FMP's Manage Database window, select the summary field configured to display the number of unique records, double click that summary field's name in the list of fields in the Manage Database window, click the OK button in the Options for Summary Field dialog, then click the OK button in the Manage Database window, the summary field then displays the number of unique records in the table.

      This is reproducible upon demand.

      Steps to reproduce the problem

      Explained in excruciating detail in my posting at

      http://forums.filemaker.com/posts/8379aed629#152379

      Scroll down to my fifth July 14 posting in the thread, or search for "Can you please help with questions 2" in the thread.

      Expected result

      The summary field should display the correct number of unique records in the table (based upon the ID key field).

      Actual result

      The summary field remains blank (empty) until I perform the added steps described above.

      Exact text of any error message(s) that appear

      None

      Configuration information

      Please see posting at

      http://forums.filemaker.com/posts/8379aed629#152379

      Scroll down to my fifth July 14 posting in the thread, or search for "Can you please help with questions 2" in the thread.

      Workaround

      open FMP's Manage Database window, select the summary field configured to display the number of unique records, double click that summary field's name in the list of fields in the Manage Database window, click the OK button in the Options for Summary Field dialog, then click the OK button in the Manage Database window, the summary field then displays the number of unique records in the table.

      I have attached a screen capture.

      Summary_field_%28sUniqueCount%29_is_blank_under_Snow_Leopard.png

        1 2 Previous Next