Ticketing program for community theater

[Bill]

Greetings,

Our community theater does six productions per year with six shows per production and have 17 rows of 10 seats each for a total of 6120 unique seats per year. All current ticketing is done manually on a paper seating chart so we have no digital tracking of patrons and a mile long paper trail.

I envision an interface illustrating the seating chart (170 boxes on a form) each form with a diffrent date. The order taker would have the ability to click on a particular seat to bring up a new patron record. Once the data is input (Name, phone, email, payment type, etc.) the color of the box changes to indicate it is no longer available with the patron name in the box. It would be nice if it would be easy to populate adjacent seats with the same data in the case of multi-ticket purchases.

I would also like to store the records of patrons for future mailings and communications, the details of which I can handle my self.

There are store bought solutions but I think I can do this myself with a little direction.

Do you feel access is the proper program for this?
Will it lend itself to this application?
Has anyone created a program similar?
Is there any design considerations I should know?

There are the seat/row and date field combined will create a unique key.

Thanks in advance for your input.

Bill

[maximus]

yes access will be just fine i had designed something similar and will be happy to help you out

the only thing that I want to know is that do you have individual seat numbers like 26,27,28 or do you lookup seats with grid ref like Col1,Row2

if you can give me this information i will give you a complete design pattern.