Ah-ha! Took me a few minutes of fiddling and a refresher on multi-table queries, but I figured it out. In case anybody stumbles upon this from Google and is new like me, here's a step-by-step to make shoji's suggestion happen.
Before you start, I'm assuming that you already have a basic...