
Newbie Formula Question

I think this is quite basic, but I'm new to all this and still learning! I have a table of contacts and one of the fields is a choice field that lists about 50 or so electoral ridings and I have selected the riding for each contact. I'd like to have another table that lists all the ridings and totals the number of contacts in each riding. So I created a separate table with all the ridings listed as separate records and then linked this table to contacts. In that separate table, I created a function field, but I have no idea what function would then pull from the electoral ridings choice field of contacts in order to total them up. Or even if that's possible. thanks anyone who can help!
-
I think you have to make the connection the other way around. I believe you want to count the amount of Members of this Riding. What you count now ist the number of Ridings that this Contact has.
If you look at my example database you'll see that I have a function field inside of the table 'Ridings' where I count the connected Members with
cnt(Contacts[Type = 1])