Possible to update queried layers automatically when modifying base layer's data?

Discussion created by sankalptikiya on Jun 12, 2014
I have a map of certain oil wells in a state. This production data is updated frequently (once a month) and I have Related them to
their respective waste reports (one to many relationship).
A series of simple queries based on location and attributes are my other layers.

So my question is if it is possible to have these queries update when the new reports come out. My bosses want to use this map but without having to learn or sit and operate a query every time new data comes out.

If there a way I can automate the entire process to auto update the queries?

Examples of queries used:
1. Select wells in a particular county
2. Select wells by proximity to a facility
(it has to create a new layer for them to see it on the map)

I'm new to ArcGIS and any kind of help would be appreciated!