Display data on Map

[Dasgeek]

I have a summary feild that totals for each county in a state. I would like to display this data on a state map with each county total displayed in the county on the map. Is there a way to do this? I have looked around but have not seen anything.

Thanks.

[Vaughan]

Well, you could paste a map onto a layout then put calculated totals onto all of the counties.

[Dasgeek]

That is the direction I was thinking, but I have summary fields that total the county numbers.

[Fenton]

Create a table for Counties, with a relationship to the number data table. Create a calculation field:

Sum ( relationship::number )

That gets you the count per county in a field in its record. But to put it arbitrarily on a map, you need more flexibility. You could use a Cartesian relationship (X). That would get you all the counties, each in a row of a portal. Then, using 1 row portals, you can put a portal with only row 1 wherever, then a portal with only row 2, etc.. They would all have the same count field inside.

[netbooee]

anyone know of where I can find a template that has a U.S. map that can display one data point in each state?