I have two tables "Tbl_Building_Information" and "Tbl_Schedule". What I am trying to accomplish is:
1. To make sure that every Active building in the Tbl_Building_Information table is also in the Tbl_Schedule table
2. To make sure that every building that is in the Tbl_Schedule table has the Current field check but only once per building.
3. To create a Report that will a) tell me if there is a Building that is not Scheduled and b) let me know if there are Buildings in the Schedule table missing a Current status or have duplicate Current status.
I feel like somehow there has to be a union query involved but I can't put my mind around how to begin this process. Any help is appreciated. I have attached a sample database.