I need to display polygons as different colors based on a value in a separate data table that I've imported from Excel. The polygon attribute table and data table both have a field with the polygon ID#, which I'm trying to use to join the 2 tables.
There are multiple entries for each individual polygon in the data table (each month over 14 years has a value). I've tried doing a one-to-many join based on the polygon ID (called 'toparea' below), but only the first set of values is appended to the shapefile (ie, only Jan 2000 will join to the polygon attribute table). I need to display the 'new_cpue' values for Jan through Dec for 2000-2014. Here is what I'm getting when I try to join:
I created the shapefile with the polygons manually from a set of coordinates, and it has all the underlying spatial information. There is no spatial information in the second table I imported except for the ID# of the polygon.
Relating the 2 tables works fine. When I relate I can select the polygon and get the information contained in the related data table, but I can't display the information for the polygon from the related data table, which is ultimately what I need to do.