What I'm looking for doesn't sound difficult, but cannot find a 'relationship' plugin anywhere that allows what I need;
Two Custom Post Types exist ('Guitarists' and 'Drummers')
Custom Taxonomy ('Location') allows post to be assigned against hierarchical terms e.g. 'France' (parent term) 'Paris' (child term).
If a post is about a 'Guitarist' in 'Paris' I want to be able to show 'Drummers nearby ....' and list the CPT of 'Drummers' in that same Taxonomy child term.
would appreciate opinions on if achievable with posts 2 posts?