By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,222 Members | 1,728 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,222 IT Pros & Developers. It's quick & easy.

Diary/Booking system question

P: 4
Hi im currently messing around with creating a diary/booking system for a leisure centre. And im stuggling with how I can display all the data. The booking is taking the activity the customer is doing and the date and time etc.

I want to display the data with each different activity having its own column and the rows having times. So that you can view a full day and see what is happening with each activity at all times of the day. Basically I want a full days view of times down the vertical, activities horizonal and any bookings populating the right places.

Any recommendations of where to start and what sorts of things im gonna need to do?

Thank you!
James
Dec 21 '07 #1
Share this Question
Share on Google+
8 Replies


Rabbit
Expert Mod 10K+
P: 12,366
Well that's a broad question. Start with the Database Normalization and Table structures tutorial.
Dec 21 '07 #2

P: 4
Sorry I'll reword the question. Ive got all the data input in tables and everythings working fine. I just have no idea how to format the output into a diary or calendar like look.
Dec 21 '07 #3

Rabbit
Expert Mod 10K+
P: 12,366
How you go about doing that will depend on how your tables are set up. So how are your tables designed?

TableName
FieldName; PK/FK; Data Type
Dec 21 '07 #4

P: 4
Heres the tables:

tblBooking
BookingID; PK; Autonumber;
CustomerID; FK; Number;
InstructorID; FK; Number;
ActivityID; FK; Number;
BookDate; Date/Time;
BookTime; Date/Time;

tblActivity
Activity; PK; Autonumber;
ActName; Text;
ActPrice; Currency;
Dec 21 '07 #5

Rabbit
Expert Mod 10K+
P: 12,366
Could you also provide an example of how the result should look?
Dec 21 '07 #6

P: 4
Heres something I just created in excel.

Thanks very much for your help Rabbit

http://www.sarje.co.uk/resultslooky.jpg
Dec 21 '07 #7

Rabbit
Expert Mod 10K+
P: 12,366
Hmm looks difficult.

I don't know if you can do all three, maybe if you used an expression to concatenate the three. But you're probably looking at a crosstab query.
Dec 25 '07 #8

100+
P: 132
I'm not sure if I understand the question correctly. Do you want to know how you can make a this booking system look?

If you want you can take a look at my page: http://www.lookandlisten.be
I'm a freelancer and my customers can use this tool to book me to do a job for them. They just click a date that is still available (when the date is blue it's not available and you can't click on it, if the date is available it's green and you can click on it, and if the date is diagonalised, it means that a bookingrequest has been made but not yet approved by me). When they click on an available date, they get a window and can fill in the neccessary information. If they click on the submitbutton, they receive an e-mail and I receive an e-mail. I then confirm or decline and they get another e-mail with my approval or my decline with explanation.

Go ahead and try it.

If this wasn't your question then just ignore this post ;-)

Greets
Dec 26 '07 #9

Post your reply

Sign in to post your reply or Sign up for a free account.