I am developing a website for The Sandlot Society (www.sandlotsociety.com). It is a baseball-oriented group focusing primarily little league players. Since most of the members are under age, we will require that a parent register with the web site and make any purchases, schedule events, etc on behalf of their children.
My plan is to create events for which the parent does not "sign up" himself for, but rather purchase as a seat or "ticket" for his/her children. Some parents have more than one child that may attend an event. When the parent purchases an event, he may buy one or more for his children. Now comes my problem: We need to collect the names of the children who will be attending the event. Think of it as selling "tickets" to an event than are person-specific.
I'm imagining that when a parent fills in the quantity of "tickets" to purchase, he will be presented with a space to fill in the names of his/her children that will be attending. If he purchases three "tickets", the he would have to enter three names for the attendees. This would occur before the "tickets" are added to the shopping cart.
I also imagine adding a table to the MySQL database something like 'event_attendees' that would have a record for each name attending the event linked to the event by the nid for that event.
I've explored the eCommerce modules a bit and do not find anything that fits my needs. Before I spend considerable time exploring Ubercart I would appreciate some feedback from you experts regarding whether the concept I have in mind is doable via Ubercart straight "out of the box" or whether the basic elements are there and I would need some custom development work to make it happen.
I also am open to suggestions regarding alternative ways to address the issue of parents buying events for their children and specifying the child's name as a part of the purchase process.
Thanks in advance . . .
