So my problem is here.
I have two tables one that has all the census data and the other that has observation data based off the FID that is found in the census data.
here is the structure for table 1
structure for table 2
FID, other information
the data in table one has multiple values going to FID 10
I really want to join the table with the layer using FID but whenever I do that only the first row is populating to the table. I am trying to use temporal analysis and look add the data using a time slider but I can't get passed this hurdle. Any help would be appreciated.