So you're saying have sponsor and sponsor w/ exhibit as 2 different groups?
And have the perks assigned to the groups?
Maybe, I need to think about it and how involved it'll be to change the
Thanks for the idea!
On Tue, May 15, 2012 at 9:03 AM, Russ Michaels <russ@mich...> wrote:
> could you do it with groups.
> assign a user to a group, and the group they are in defines what perks they
> have ?
> a perk can of course be in multiple groups, thus the lookup table
> On Tue, May 15, 2012 at 2:49 PM, Greg Morphis <gmorphis@gmai...> 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,
> > 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
> > 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
> > which if the perk involves an amount of free registrants then they
> > 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!