Relationship Mushroom

Been working on the guest database today, between strimming grass and wall mounting hose reels, as you do.  If there's a reason to hate Microsoft, then Access has to be a good one.  It's not so much that it doesn't work, because it evidently does, it's rather that the user interface is both unfathomable and inconsistent.

Online help is no better. I see 50 versions of the equivalent of "how to turn a steering wheel'" and none of "how to go round a corner".

Apparently my many-to-many relationship needs a different sort of join. 

Well, yes.