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:351158
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm