I have a building footprints layer with the name and other data about the building. I have a table which details "work requests" such as maintenance requests from users of these buildings. The work request data details the TYPE of request (electrical, mechanical etc) and the date and building name. I am trying to associate these work requests to matching buildings accordingly so that i may display each request as a dot on top of the building. The purpose is to create a time lapse video of all the different work requests that occur throughout the year. I do not want to manually create each feature (over 1000) and place on top of each building. I want something that can be updated year after year.
I've looked into make a query table..and also relationship classes.