AnsweredAssumed Answered

Count Number of Records from Related Table

Question asked by Terri on Mar 27, 2013
Latest reply on Mar 27, 2013 by Terri

Title

Count Number of Records from Related Table

Post

     I have two tables:
      
     Workhorse Data - contains all the styles and each color available for that style. So there is one style and it has 5 colors so that style actually has 5 records.
     Workhorse Styles - I import records from the Data table but validate the style as unique only, so this only shows one record for each style. 
      
     I'm trying to figure out how to show on a layout from the Workhorse Styles table (Layout is called Reports) the number of colors that have a status of adopted for that particular style (this information is on the Data table). 
      
     Example:
      
     Workhorse Data Table:
     Style 123456
     Color A - Adopted
     Color B - Adopted
     Color C - Dropped
     Color D - Adopted
      
     Reports Layout needs to show:
     Style 123456
     Count of colors adopted = 3
      
     I hope I gave enough information. I know how to add a summary field that is created from the Workhorse Data table and put it on this layout but it shows the total count of colors, not a count of only adopted colors. 
      
     Thanks!

Outcomes