Booking Form (pls help)

[Guest_imported]

Hi People,

I will try and explain this best i can but it really is confusing me, so help would be appreciated greatly thanx.

Well i am trying to create a booking system using access for a sports club. I think i have gone the right way about this. I have created all the forms for the different facilities avaliable and the times slots that are avalibale. now the tircky bit. i wish to link all of these forms onto a main booking page. I also wish for it to be able to recognise when facilities are double booked. I think i need coding, but i am totally unsure as to what it is.

Hope that made some sense.

Thx alot

 

[LittleSmudge]

I'm sorry to say that I think you're working backwards down the process and that is why you are getting confused.

You need to start from the Tables.
What is the structure of the relational database that will hold your data?
What are the data tables?
What are the lookup tables?
What are the linkage tables?

Is this design robust against all the various data packages that a user will ever want to store in the database?
Does it support all of the data output structures that will ever be asked of it?

Is the design Normalised?
If not, document WHY you have chosen not to use a normalised structure in each instance. ( This process alone often help solve data structure problems. )


Only after you are sure of the structure and that it will work in ALL real world situations sould you even consider sorting out the pretty front end, which at this poiint becomes a simple process of representing the data table structure into forms and reports.



G LS

 

[Guest_imported]

i have produced tables and then created forms out of them.

Data tables are the members information and the different time slots avaliable for booking

Lookup tables will be the booking form that needs to be produced

I will need all tables to be linked. for example ,if someone wants to book a facility, you click on the time slot and it will bring up the different members and you choose which one.

As you can see im very very confused. But what it comes down to is a functional booking system that inter links and so far im aving no luck at all

So any more suggestions would be gratefully recieved.

davhhh@hotmail.com is my msn if any1 wants 2 contact me

Thx alot