We actually have a pretty limited number of users, who are paired as mentees and mentors. We want each mentor/mentee to be able to select their corresponding mentee/mentor from the list to make sure the spelling is the same. We also want to show linked pairs in another section, which is another headache all to itself.

The first name and last name are stored as xprofile fields because I needed the privacy and user controls that Buddypress provides. Role is also stored as an xprofile field because we’re using our own defined roles (mentor and mentee).

Looks like I’m going to have to get deep into the SQL to do this – was just hoping there was something easy I’d missed!