My overall objective is to create a timeline 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 approximatly 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 shape file, 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.