How to script? From a single column: Fill 2nd table with unique values, then count total of each value in second field
I have Table A - 25,000+ names. It contains a field "County" for county residence. I want to fill an empty, Table B with the list of uniques in one field, then a Count of total occurrences for each county. Table B:CountyID as key.
Ideally, a rerun of the script when name data updates are sent would generate a new list of counties and a new count.
I do some FM scripting - enough to be dangerous. But this is over my head. Any help? Any examples or snippets so I can see clean code? Thanks in advance.