My ERD is beginning to grow to have over 10+ tables. I need to be able to create a report on my clients that shows specific information from a collection of tables ( related to my client ) that are gathering specific information of my client.
This is what a sketch of my ERD Looks like there are other tables but they are not associated with the functionality of creating THIS specific report. My question is, right now I have a "Treatment Report Table" where I am storing things that don't make sense to store in any other table. I am planning on creating a form from this table that uses all the information I am storing in my Treatment Report Table AND it also has to grab goals from my Goals Table, organise them according to their type of goal, grab specific information from my client's insurance from his Insurance Table, grab specific dates from my Authorization Table, grab employ information from my Employ Table, and finally display a whole lot of interview questions and responses from my Interview responses Table and interview Questions Table.
Does my ERD make sense?
Is there a better way to get the functionality I am looking for?