Well the registrant is either a Sponsor or Exhibitor type (right now), it's just that Sponsors could also Exhibit. Almost as if I need a flag or something.. but I still need to be able to pull additional perks. I'm not sure what you're asking though.
On Tue, May 15, 2012 at 9:33 AM, Scott Stewart <[email protected]>wrote: > > can you set up "exhibitor" in the sponsor table and link it to it's > acompanying perks? > > think of the sponsor table as a level table instead of a sponsor table > On 5/15/2012 10:28 AM, Greg Morphis wrote: > > Right there could be multiple sponsor levels per conference and each > COULD > > exhibit and get additional perks based on if they also choose to > exhibit.. > > For example: > > > > Bronze: > > 1 free guest > > > > Bronze + Exhibit: > > 1 free guest > > $300 off Exhibit fee > > > > Silver: > > 2 free guests > > Free access to bonus event > > > > Silver + Exhibit: > > 2 free guests > > Free access to bonus event > > $500 off exhibit fee > > > > They could also JUST exhibit and not be a sponsor in which they would > get a > > different perk entirely.. > > > > The system works for the sponsor level just fine, but NOT if they want to > > be a sponsor and choose to exhibit. > > > > They register as a sponsor, choose Silver level and if takes off 2 guests > > fees.. but I need to be able to ask "Would you like to exhibit?" and if > so > > then apply the discount perk to the total. > > > > > > On Tue, May 15, 2012 at 9:19 AM, Scott Stewart<[email protected] > >wrote: > > > >> Just My $.02 > >> > >> It sounds like a registrant can gave multiple sponsor levels, link the > >> sponsor level to the registrant as a one to many (one registrant can > >> have multiple sponsor levels) > >> with the perks based on sponsor level, as a one to many, you should be > >> able to query for perks by registrant, through a couple of joins > >> > >> On 5/15/2012 9:49 AM, Greg Morphis wrote: > >>> I'm working on a registration system and I'm trying to add the ability > to > >>> add perks and discounts based on registration type. > >>> For example, if you register as a bronze sponsor you get a free guest, > >> but > >>> if you sponsor and exhibit you get the free guest plus a discount off > the > >>> exhibit fee based on the sponsor level you choose. > >>> > >>> I'm having a hard time making it dynamic, I just can't see it > happening, > >>> tunnel vision or something.. Any ideas or thoughts would be > appreciated. > >>> The system is set up like > >>> attendee (general information) > >>> attendee_conference (conference specific information per attendee) > >>> attendee_conference_sponsor (if they choose to be a sponsor, this has > >> their > >>> sponsor information) > >>> ... > >>> > >>> The back end has: > >>> conference (main conference table) > >>> conference_sponsorlevel (has the various levels per conference) > >>> conference_sponsorperks (one to many, sponsorlevel_id to perk) > >>> > >>> The perks are not standardized, but one almost always perk is a number > of > >>> free guests.. > >>> so I have a column in the conference_sponsorperks table > >> "compedRegistrants" > >>> which if the perk involves an amount of free registrants then they > >> populate > >>> that and it works it into the total. > >>> > >>> But how would I add "if and only if they're an exhibitor then take, say > >>> 300, off the total"? > >>> > >>> Thanks! > >>> > >>> > >>> > >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351165 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
