I believe the old affiliate program was pretty much shot in the foot (or stabbed in the back?) when the CFC started doing auto-renewals of memberships. Of course the affiliates didn't get cuts out of THOSE even if they sold the initial membership.
Perhaps a hybrid of that and your plan Michael?
Let clubs be affiliates. Let members belong (or not) to one. If they do then the affiliate gets a small cut of their membership no matter how they renew. The CFC can add one item to their database so they can keep track of which club everyone is a member of (only for affiliated clubs of course).