CiviCRM Community Forums (archive)

We have about a 1000 local clubs (Organizations in CIVICRM Talk I suppose ) and when a member signs up we want them to be able to select which club they are affiliated with.  What is the best way to accomplish this task?

Then we want to relate the local club to regional sporting group, I assume that is relationship based and i think I have that accomplished but I am unable to add an orgainzation to an individual, as a profile.

I have a profile with all thier basic info, I just need to allow them to select their club from a dropdown.  The Clubs pay membership fees too and have expiration dates, should they be entered into CIVCRM as individuals instead of clubs?

Thanks for any help for a newbie!

Thanks for the reply I am using Joomla 2.5 flavor of CMS.  And yes I have made the club a subtype of Organization so at least thats a good thing   Techn

I saw the relationship setup but on the member profile when i add the clubid, its just a text field.  How can I make that a select list of all subtype Organization clubs?

So on the member signup profile I just want a dropdown list of all Club Organization Names for the member to affiliate with, But of course the list is dynamic from CiviCRM.

Thanks!

David

I have read some of the api documentation but I'm not seeing an example of what I want to do, perhaps I'm overlooking it.

I have the rowsource for an html dropdown and i get that you have to set it to read only and put a special .php file in the correnct folder but I guess the code to make the hook happen I'm not getting.

Sorry for being a trouble

David