I am trying to create a database to keep track of company grievances. There are 12 divisions and 5 consultants. Each Division has only one consultant assigned to it, but each consultant can be in charge of more than one Division. The consultant then handles all of the grievances for that division. Each division can have many grievances. Also, the consultants can only update data about their divisional grievances but they can view the grievances from all the Divisions. The ERD that I keep coming up with is a circular one! I am using four tables: tblDivision, tblConsultant, tblUserAccess, tblGrievanceInfo. If anyone has any suggestions please let me know. Also if this is not clear also let me know and I will try to be clearer.
Thank you