I have a website running on a competing CMS that I am considering converting. Most of the conversion seems fairly straightforward but I have two custom modules there that, after reading through your documentation, I don’t see a clear path on. One module is a club membership system. The other is a bicycle ride calendar. Basically, the modules start by checking users’ information, privileges and group memberships and then presenting a series of forms to fill in data. Some of the data is just plain vanilla text entries ... I can see easily how to do these using form_helpers, form_validation and the like. But some of the data is presented in select drop down boxes with options that are determined by database lookups. So, for instance, I might have a list of potential ride leaders for a ride where the leaders (options in the select box) are determined by reading the membership table and putting the results into variables that are then put into options.
I don’t see where I do this in the Expression Engine engine so to speak. Would I make the membership one “channel” and the ride calendar entries another? Do I need to create my own “module” presuming that “module” has any meaning within EE? Can you point me to some existing code that has select boxes and options on forms that are derived from reading database tables. Is there some code somewhere that shows samples of fairly complex form-validation-database update sequences where I could see how all the pieces fit together?
Thanks.