I start to understand modifying reports until something I think is simple just doesn't work. 

For our work order, I am trying to separate the edgebanding count by the comment field of our parts. We do trim, doors, etc. and that is defined in the comment field of our parts. Basically saying we used "X" on doors easier. 

How do I get those two tables to talk to each other and then use that in the group header? I keep making relations but I swear I am not getting anywhere with it.