My overall objective is to create a time line animation depicting when a person is working in a particular region. The .dbf table consists of over 6000 record entries of shift data, including date start and date stop times along with an assignment ID. I have approximately 100 different shapes/regions also with assignment ID's. I would like for that region to turn on or off based of the table shift data and show when someone is working that region.
When I join the table to the shapefile, only the first shift entry gets attached and displayed. Do I have to have 6000 shapes for each of the 6000 record entries?
There has to be a better way, please help.