Hi all, not sure where to really start with this, but i'll try and explain what I'm trying to do.
Basically I have 3 tables.
tblFilm that has filmID and title in it
tblScreen that has screenID and capacity in it
tblShowings that has filmID, screenID, tickets, Date and time in it
The tblShowings has about 30 records in it at the moment. There are 30 records, but the data is just about the same. There are only 3 dates (10 of each) - that is important, you'll find out why in a mo!
So what I want to do is have a list of dates (unique so only 3, not 30!) which the user can select to display all of the films that are being shown on that day and the different showing times as well. So basically the tblShowings data. They can then click
on the film that they want to see and book tickets. That bit isn't a problem. My problem is what is the best way to do this? Display the dates (eventually there will be 7 dates as I want it to be for the up coming week), allow the user to select the date they
require and display the relevent data. Can this be done or am I being a bit too ambitious?
Should also let you know I am using an Access DB as I can work on it from home!
liamh
Member
30 Points
25 Posts
Best way to...
Jun 06, 2007 03:11 PM|LINK
Hi all, not sure where to really start with this, but i'll try and explain what I'm trying to do.
Basically I have 3 tables.
tblFilm that has filmID and title in it
tblScreen that has screenID and capacity in it
tblShowings that has filmID, screenID, tickets, Date and time in it
The tblShowings has about 30 records in it at the moment. There are 30 records, but the data is just about the same. There are only 3 dates (10 of each) - that is important, you'll find out why in a mo!
So what I want to do is have a list of dates (unique so only 3, not 30!) which the user can select to display all of the films that are being shown on that day and the different showing times as well. So basically the tblShowings data. They can then click on the film that they want to see and book tickets. That bit isn't a problem. My problem is what is the best way to do this? Display the dates (eventually there will be 7 dates as I want it to be for the up coming week), allow the user to select the date they require and display the relevent data. Can this be done or am I being a bit too ambitious?
Should also let you know I am using an Access DB as I can work on it from home!
Ta!