Education questions

Thanks Grae,
That's t really interesting.

Can I ask you about the Customer Data tab. I have looked and and I cant seem to add any extra information to it. Am I missing something obvious?

Jean Baynham
Box Office Supervisor
Cheltenham Festivals
+44 (0)1242 505444
http://cheltenhamfestivals.com

The Cheltenham Jazz Festival 27 April - 2 May 2011
The Times Cheltenham Science Festival 7 - 12 June 2011
The HSBC Cheltenham Music Festival 29 June - 10 July 2011
The Times Cheltenham Literature Festival 7 - 16 October 2011
Address: CF Ticketing, Unit 77, Regent Arcade Shopping Centre, High Street. Cheltenham GL501 1JZ
Cheltenham Festivals Ltd: Charity No 251765 / Vat Reg No 100 1140 13

________________________________

From: Tessitura Education Forum on behalf of Graeme Ellis
Sent: Mon 21/03/2011 17:21
To: Baynham, Jean
Subject: Re: [Tessitura Education Forum] Education questions



Hi Jean,

We work it similarly to Patrick at Milwaukee Rep. Schools records have individual teacher records associated with them. All the bookings live on the school record and we link the teacher's record to the order as well in the 'Custom Data' tab on the order.

This is quite handy because we can also track a teacher if they move schools.

Does that make sense? Let me know if you have any other questions.

Grae

From: Jean Baynham
Sent: 3/18/2011 7:54:36 AM


Hi Graeme,

What would you advise about adding schools to the database? Can a school record be added with multiple names attached to it , or does each individual teacher need to be added seperately? If this is the case how would you find information about how many tickets a school had bought overall?

Hope that makes sense. I would be glad of any advice

Jean Baynham

Cheltenham Festivals Box Office




This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Education Forum. You may reply to this message to post to the Education forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This E-mail message, including any attachments, is intended only for the person or entity to which it is addressed, and may contain confidential information. If you are not the intended recipient, any review, retransmission, disclosure, copying, modification or other use of this E-mail message or attachments is strictly forbidden. If you have received this E-mail message in error, please contact the author and delete the message and any attachments from your computer.
You are also advised that the views and opinions expressed in this E-mail message and any attachments are the author's own, and may not reflect the views and opinions of Cheltenham Festivals Ltd.
www.cheltenhamfestivals.com

Hi Jean

We configure all our custom data tabs using a SQL stored procedure and an InfoMaker object.

There is some documentation on custom tabs stored on the T drive (or your relevant drive):

T:\Documentation\IT and DBA Documentation\Customizations

Hope this helps.

 

Mark

Hi Jean

We configure all our custom data tabs using a SQL stored procedure and an InfoMaker object.

There is some documentation on custom tabs stored on the T drive (or your relevant drive):

T:\Documentation\IT and DBA Documentation\Customizations

Hope this helps.

 

Mark