1 Reply Latest reply on Oct 25, 2010 2:25 PM by philmodjunk

    COUNTING THE NUMBERS FROM ANOTHER LAYOUT

    khank

      Title

      COUNTING THE NUMBERS FROM ANOTHER LAYOUT

      Post

      I have one layout named "seasonnums" with a field named "meetnums", at this time I have only 7 records.  

      I know the number 10 has repeated 2 times, 20 has repeated 3 times and 30 has repeated 2 times.

      Example:

      10

      10

      30

      20

      20

      20

      30

      The second layout named "numlist" has 3 fields titled 10, 20 and 30.

      I'm wanting to do is "count" the respective number from "seasonnums" field "meetnums".

      Not as a summary because I want to use those totals later on.

      Example:

      10 = 2

      20 = 3

      30 = 2

      I have the "relationship" between the layouts, but how do I count (total) the individual numbers and update as further records are entered.

      The solution is escaping me at this time.