Caluclating total cost of sales

[Whitchurchcomputing]

Hi all,

I have created a project where I have to book different seats for a theatre on two different days, each seat is a different record and seats vary in price. I was wondering how I could create a form to calculate the cost of every sale of the seats booked?

Thanks in advance

 

[jdraw]

The Form would come after the database design.

Seems like should have tables such as ( guess)

Seat ---->SeatPrice--->Booking<----EventSession<--Event

and Customer