Yes, the design you outlined is how it's currently developed for the many-to-many.
I know I could use the language to format it, I was just hoping that I'd be able to make this a little more efficient by returning one record instead of many. Don't get me wrong, our network isn't that bottlenecked.. I'm just neurotic and a little OCD about keeping bandwidth and CPU to minimum.
Thank you for your advice.
If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link.
* The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".