472,793 Members | 2,275 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,793 software developers and data experts.

Design of ticket sales database

I am a novice where Microsoft Access is concerned. I am retired (age
63) and have been asked to design a ticket sales database tracking
customers, peformances/events, tickets sold, reserved seating and
associated reports. This project is for a non-profit community theater
and I am attempting this project as a volunteer - no salary or
compensation of any kind.

I have designed the base tables (customers; seating; performaces;
pricing; etc.) and they work.

My problem stems from attempting to design a functioning specific
assigned seating (row and column format) and having the sold seats
decrement from the master list by row and seat.

The data entry forms work well, i.e., I can assign seat numbers and
rows and link them to customers - but I'm unable to find a method
through which to increment/decrement assigned seats from the master
seat listing. This is a critical component of the design, as the
operator of the database will need to know which seats are still
available (unsold) for the next customer.

It is quite possible that this forum is not the place to ask these
questions - and if so, please accept my apology for injecting my
questions to the group.

I would be most appreciative if anyone can direct me to a forum or
other locale which might afford me some insight and assistance in
completing this project.

Thank you for any assistance you may be able to provide.
Sincerely,
Access_Novice

Nov 13 '05 #1
3 5552
rkc
access_novice wrote:
I am a novice where Microsoft Access is concerned. I am retired (age
63) and have been asked to design a ticket sales database tracking
customers, peformances/events, tickets sold, reserved seating and
associated reports. This project is for a non-profit community theater
and I am attempting this project as a volunteer - no salary or
compensation of any kind.

I have designed the base tables (customers; seating; performaces;
pricing; etc.) and they work.

My problem stems from attempting to design a functioning specific
assigned seating (row and column format) and having the sold seats
decrement from the master list by row and seat.


<snip>

The solution is to base your input forms on queries that don't
show what isn't available. Noone can give you specifics on how
to implement that without you giving more information about
the structure of your tables.
Nov 13 '05 #2
Presumably you have a "sold" column somewhere that you can tie in to the
customer and his seat allocation. Run a query that can show seat row and
column numbers as well as the sold field and just filter it by typing
into the the criteria of the field Is Null. So long as you leave this
sold field empty until sold the query will only show available
combinations. I agree with last answer also though, I am only guessing
at the structure and putting some ideas forward. Good luck

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3
You have the master seat listing, and that never changes, nor does it need
to be modified in anyway

(unless the building is being renovated!!!).

So, assuming you assigned some seats to some people for a PARTICULAR event,
then
you an simply query the system to get all seats assigned to those people for
the particular event.

So, if seat 34 is taken, then you might have (this is air code that probably
could actually run, but
is only for instruction here).
dim strWhatSeat as string
dim rstRecs as dao.recordset

' lets assume you have alerady selected what event/show

lngEventId = 123 ' this is the event that was selected

' now, what seat?
strWhatSeat = inputbox("what seat")

strSqlWhere = "EventID = " & lngEventId & " and SeatNum = " & strWhatSeat

if dcount("*',"tblBooking",strSqlWhere) > 0 then
msgbox "sorry, that seat is booked"
end if

So, the idea, or logic here is to simply search/look at existing bookings
for the particular event, and check if the seats have been assigned.

This means your design approach never have to actually modify, or change
anything in the seats listing table. You only look at the particular event,
and check if those seats are taken in that event. This design approach means
you don't have to create "slots", or a list of records with the seat list,
but only have a master seating list that gets used over and over for each
event. Each time you book people into a particular event, you assign a seat
value, but always check/ensure that the seat is not yet sold...

It is not at clear what your table designs are now, but I think the above
ideas and concepts will help you.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Lefevre, Steven | last post by:
Hey folks - Thanks to everyone who gave input to my concerns. Of course, we don't intend to have the mysql port open to the world. We will have Apache/PHP connect on a unix socket, or to another...
0
by: Krist | last post by:
Hi All, I have a database design question, pls give me some help.. I want to define tables for salesman's sales target commission . The commission could be given per EITHER sales amount of :...
1
by: Krist | last post by:
Hi All, There is some additional info I forget on this same topic I just posted. I have a database design question, pls give me some help.. I want to define tables for salesman's sales target...
22
by: Nunaya | last post by:
We have developed two objects called "customer" and "salesrep". For simplicity, assume that these two objects will talk directly to a database. The database has three tables: customers,...
7
by: grawsha2000 | last post by:
Hi, I'm designing a simple database for filing system: There are two levels of files (both look_up tables): tlkpFile1, tlkpSubFile1 and a transaction table, tblFilings, for filings (when...
6
by: kossanah | last post by:
I like to seek to your assistance in any measure.I need your help on how to go about This: I am developing a promotional site where user will be issued a ticket(manually) which will be a...
23
by: JohnH | last post by:
I'm just recently come to work for an auto brokerage firm. My position involves performing mysterious rites, rituals and magick in order to get information out of their access database. This is...
9
by: rumkus | last post by:
my ticketlog table as below salesperson beginno endno name1 201 250 name2 251 300 When I used ticket 288 on my sale form I should not let second record to...
2
by: igovada | last post by:
Hi I have a table (Sql server 2000) which has 14 cost columns for each record, and now due to a new requirement, I have 2 taxes which needs to be applied on two more fields called Share1 and...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
0
by: lllomh | last post by:
How does React native implement an English player?
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.