Too many Table Occurrences
In my Library db, I've created a statistics layout where I show, amongst other things, how many books of each type there are in the Library. Ex.: novels = 100; poetry = 25, etc. The problem is I have 42 different types and I had to create 42 different TO to filter the different types. I'm getting all the right results so that structure works ok. But the relationships graph looks terrible. Is there a better way to do this that would avoid the need for so many TO?