It's not looking great to me. Aside from the fact that I don't see a tblCommunity_Consensus, I see tables with PK fields and no foreign key for them in any other table. Also see 2 id fields in the same table, repeating fields in tblSchools and question the comm_code being in every table. I question that there is no link between what looks like a one to many (or parent/child if you prefer) between communities and services.
I think you should review db normalization and see if you can fix all of this, or post a detailed description that explains what it's all about. Whatever explanation you give, expect more questions because there's no way for you to anticipate everything we'd need to know. Maybe start with the links in this thread
https://www.accessforums.net/showthr...773#post521773
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.