Booking System

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello,

As a student i was given the task to create an application for a local
theatre. Except i am struggling on how to implement this. I have been
told the project must be done using Visual Basic 6 and a database.
Currently i have a database of customers and shows and have no clue on
where to go. (seprate files for each show perhaps?)

What i was thinking was to have a form with 100 labels on, and they
would be red if that seat was booked or green if it was available for
that show. To book you would have to click on the label and a form to
select the customer, which would update the previous form.

Any Useful tips or help on what tables are needed are appreciated.

Thanks

.

Relevant Pages

  • Re: Booking System
    ... Read up on Database Normalization. ... > Currently i have a database of customers and shows and have no clue on ... > What i was thinking was to have a form with 100 labels on, ...
    (microsoft.public.vb.general.discussion)
  • Re: Booking System
    ... Occupied seats would have red backcolor while available ... > told the project must be done using Visual Basic 6 and a database. ... > Currently i have a database of customers and shows and have no clue on ... > What i was thinking was to have a form with 100 labels on, ...
    (microsoft.public.vb.general.discussion)
  • RE: Store Added Value List Items
    ... You could even union that query with the actual list from the form ... Each user in this database needs to have access to all the same customers. ... is praticle to create a seperate one field table to store values for a lookup ...
    (microsoft.public.access.formscoding)
  • Re: Please suggest relationships model
    ... Providing Customers A Resource For Help With Access, ... However, if he wanted his database quick and painless, I provided ... Here you are in the newsgroup offering services that were NOT ASKED for. ... the newsgroups and a few larger jobs. ...
    (microsoft.public.access.queries)
  • RE: Store Added Value List Items
    ... (The Primary Key that the user updated added) ... Each user in this database needs to have access to all the same customers. ... is praticle to create a seperate one field table to store values for a lookup ...
    (microsoft.public.access.formscoding)