I have a question now that we're on v11: What makes some affiliation types show up in the drop down list and not others. And if, as I think, you're going to say something along the lines of the two records have to be of the same customer type, where do I set that? I ask because I have individuals affiliated with our company (which exists as a corporation in Tessitura for this purpose) and I'm simply adding a new affiliation of HGO Trustee (clubs), but only Officer/Trustee (clubs) shows up.
Sorry if this is an obvious answer.
I believe TX_CUST_TYPE_AFFILIATE is the system table you're looking for!