AnsweredAssumed Answered

COUNTING THE NUMBERS FROM ANOTHER LAYOUT

Question asked by khank on Oct 25, 2010
Latest reply on Oct 25, 2010 by philmodjunk

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.

Outcomes