Mapping State-Level Data
I am hoping to be able to map the totals from a related table not by street addresses, but by state. So if there are three customers in NJ (in customer table) with 8 orders totaling a quantity of 50 i...
Forum Discussion
So using Dans information you could make a table with 50 states, with the State being the Key field. If you manually key the lat longs into address 1 and address 2, they will map. Get that far and observe a map of the US with 1 pin per state.
Then you should be able to set up a relationship back to the Orders table and summarize the total Orders and use that on your map pin.
Then you should be able to set up a relationship back to the Orders table and summarize the total Orders and use that on your map pin.