function calculating ticket prices

[venus_lost]

Hi I have created a cinema/theatre datbase
and now my problem is I need to create function to do mutilple calculation when a user makes a booking
for eg. user could be adult purchasing superior seat.

Adult ticket price is $5.50, if it is superior add $1.5 more for the ticket.

vice versa consessionary $4.40 if it is superior add $1.5 more for the ticket.

Any suggestion how to go buy doing this?

 

[RuralGuy]

Just a suggestion: Make sure all of your prices are in a table where they can be changed by the user rather than hard coded into the program. It will save you some problems and phone calls later on. I would use a ComboBox to set the booking.