Hi everyone,
I'm sure this is really very easy and obvious and I'm just missing the point however I'm having a bit of a brain freeze trying to run a report or list that will tell me if any of our constituents have purchased more than four tickets to a particular production season.
We have a four ticket limit in place that we can enforce online but there is nothing to stop someone then phoning the box office and buying more tickets. Obviously our staff will try to remember to check the constituent's ticket history before selling the tickets but this is not fool proof.
We are also aware that people may simply create new logins and buy extra tickets that way but there is only so much we can do to try and enforce the limit.
Our DBA is on holiday so we can't do anything requiring complex back end work.
Any ideas appreciated.
Thanks,
Brooke
CRM Systems Manager, National Theatre
Thanks for your help ladies, I am very appreciative indeed!
I still haven't quite nailed exactly what I want directly in Tess but I've been able to mess around in Excel to a satisfying enough degree.
B