Hi all, I have a labelling quiz for you.
I have a point FC that identifies islands. Each point has a code to identify the island uniquely. There are no duplicates.
I also have a table (excel at this point) that stores info on bird colonies inventories (island where it is located (code)20, date inventoried, other info...).
The codes for the islands in the point FC and table are the same. There is a one to many relationship between the FC and the table.
I need to label each island with all the years that a colony was inventoried on it. Some will have one year displayed, others two, others several...
1978
1978
1986
1986
1999
1978
1986
1999
2009
etc.
I tried joining the tables but I only get the first year that's found in the table for each point. Now I'm thinking: can I use a python script in the labelling expression that will access my table and parse it to create my labels and return them?
I bet I'm missing something simple here...
Thanks for your time
Remi
