1:M join of temporal data

Discussion created by fauhan24 on May 4, 2013
Latest reply on May 6, 2013 by rfairhur24
I am operating with temporal data, data collected annually for 20 years. I have a grid index feature that I would like to treat as my static survey area, and I am trying to join descriptive attributes, created in summary statistics, to that table. The grid index feature table lists the unique "page number", I'm going to call it the GRIDID, for each cell. My summary statistics table has many rows per GRIDID, one for each year 1994-2012. I am now trying to join that summary information back to my grid index feature using a 1:M join but it will only accept the first summary stats GRIDID (eg. only 1994, not for every year). How do I fix this?!