Help with a Record Count
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!