Hi there,
Working on a demo for a Uni Union; one of the features required is a "Clubs" setup. I am creating a web app with student clubs able to submit and edit their page, create events etc etc.
One required element has me stumped : each club needs a 'members list' and the ability to easily create reports which show the members of a certain club (via the Admin is fine). Not something I have ever had to create before, even after God knows how many years with BC, but the CRM reports don't look like they will generate a report based on 'relationships'; which would have been a reasonably logical solution (The "Company" being a club, with the "Club Members" being "Contact" relationships).
Any suggestions from the BC crowd? I have my lateral thinking cap on, but haven't been able to come up with anything that would be simple and logical for the client to use. I know I could extend the DB, but that would mean adding a new 'checkbox' in a custom field (for example, "Member of (club):") every time a new club is created so that a contact could be 'associated with it'. May be my only option but I am trying to come up with something a little less clunky.
Thanks in advance for any suggestions!
