I am implementing CiviCRM in Joomla for a sporting organization. The way they work is they charge an annual membership for each of their affiliated clubs (e.g. 100$). The clubs also need to pay a certain amount for each of their members (e.g. 5$ per member). So the final membership cost of a club that has 10 members would be 150$ (100$ + (10 x 5$)). I have set up the contacts so that each club member individual is related to the club organization as a "is a member of" relationship. I have created a "club" membership at 100$ and a "club member" membership at 5$.
My question is: Is there a way of programming the membership renewal price set to automatically fetch the number of related contacts and incorporate it into the club's bill?
Thanks for any insight into this matter.
P.S. I started with defining the club members with a "club member" membership but this created the problem that the individuals were indicated as owing 5$ in their profile and I still could not figure out how to have the number of related members in the club's bill.