Diary/Booking system question

[shrimpeh]

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

[Rabbit]

Well that's a broad question. Start with the Database Normalization and Table structures tutorial.

[shrimpeh]

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.

[Rabbit]

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

[shrimpeh]

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;

[Rabbit]

Could you also provide an example of how the result should look?

[shrimpeh]

Heres something I just created in excel.

Thanks very much for your help Rabbit

http://www.sarje.co.uk/resultslooky.jpg

[Rabbit]

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.

[Cainnech]

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