2 Replies Latest reply on Dec 22, 2013 4:22 AM by shae1725

    Help with a Record Count

    shae1725

      Title

      Help with a Record Count

      Post

           Im looking to get a total of records in a related table

           I thought I knew how to do this and is probably really simple

           The table is populated with Colors (::ColorID) and are all in Groups (::ColorGroupID)  and I want to display how many colors in each subgroup

           I want a different table to contain the calculation (This table also contains the ColorGroupID so have a related field to join!

            

        • 1. Re: Help with a Record Count
          philmodjunk

               Do you have this relationship?

               Groups::ColorGroupID = Colors::ColorGroupID

               If so, then Count ( Colors::ColorGroupID ) could be defined in Groups to count the number or related records in each group.

          • 2. Re: Help with a Record Count
            shae1725

                 That's how I set it up and was scratching my head about why it wasn't working because it should have been pretty simple!

                  

                 But I have since worked out what  "Evaluate this calculation from the context of:" means! .... I had multiple occurences of the table in question

                 You learn something everyday :)