My site is made up of several (187 total) sub-organizations. I use CB lists to organize the members.

Each sub-organization has officers, President, VP, Treasurer, Secretary. Obviously, you have to be a member of the organization to be an officer.

A user can be a member of more than one sub-organization. I use a multi-select field to filter them.

A user can also be an officer of more than one organization. In the list, I want a column to display their position for that sub-organization only. So if they are an officer of more than one organization, only the position for that will be displayed?

Any suggestions on how to go about this? Nobody seems to reply to free users here, but I guess it's worth a shot since I can't seem to figure it out.