Booking Screen! - HELP PLEASE!

[RandomGuy123]

Hello everyone - new user here and a complete Database/Access novice.

I have some rather troubling issues with my work and I was hoping this wonderful community could resolve these issues.

I have a Database with four tables (Property, Buyer, Viewings and Agents), two forms (Search Screen and Property Screen), one query (Search Results Query) and a report (a Property Report based on the Search Results Query).

The Property table, Buyers table and Agents table are irrelevant in the issue that I am discussing however my Viewings table is relevant.

The Viewings table has the following fields:

Viewing ID (Primary Key)
Staff ID
Viewing Property ID
Buyer ID
Date Of Viewing (in short date format)
Viewing Period (drop down list that contains these values without the quotation marks: '09:30 to 11:00', '11:00 to 12:30', '13:30 to 15:00' and '15:30 to 17:00'.

My task is to create a Booking Screen. This Booking Screen must be a form.

The Booking Screen must contain the option to change the following:

• the date for the viewing
• the timeslot for the viewing (from a drop down list)
• the agent who is to be assigned for the viewing
• the property to be viewed
• the buyer who wants to view the property

At the end of the Booking Screen (the Booking form) there must be a button that can be clicked to make a booking. This button will make the booking based upon the fields (the bullet points above) and will add a new record to the Viewings table with that data.

However it should not be possible to double book for any combination of agent, property or buyer for the same date and time slot. If a double booking is attempted, a customised error message should display saying 'Booking cannot be made'.

If it possible to make a booking, the message 'Booking made' should display and the booking should be added to the Viewings table.

Things to consider:

I am a complete novice in Database so if and when people recommend options, please walk me through step by step.

Moreover if people are going to be using Visual Basic codes to help and not just formulas and queries, please can you explain each bit of the code to me.

If functions or statements such as (If and else, iif, dcount, dlookup, etc) are going to be used or queries then please let me know where to put these formulas and under which field's criteria and so on.

The option to change the Viewing Period to Start Time and End Time is not an option.

Thank you people! I really appreciate any help I can get!

 

[jdraw]

Please tell us more about this

The Property table, Buyers table and Agents table are irrelevant in the issue that I am discussing however my Viewings table is relevant.

How does a Viewing work?
Isn't a Viewing for a Property? So wouldn't property be relevant?
Many times certain Property have a lead/primary agent, which could make Agent relevant.

It would seem you do not separate a Buyer (one who has bought) from a Client (one who may buy). However if a Client has asked to View a Property, I would think the "Buyer" would again be relevant.

Maybe I missed something in what you were thinking.

Also, you self identified as

I am a complete novice in Database so if and when people recommend options, please walk me through step by step.

I highly recommend this tutorial ASAP

Welcome to the forum.

 

[RandomGuy123]

Hello and thanks for responding.

The Viewings table now that I think of it is technically the Bookings table.

www(dot)i62[/url] (dot) tinypic (dot) com/27wwpe1 (dot) jpg

The above are my Relationships for the database.

Sorry to say, I'm a bit confused. When I added the fields in my Viewing table, I did not insert existing fields but simply created new ones e.g. Staff ID, Viewing Property ID, Buyer ID.

Moreover I have formulas in other parts of the database that are dependent on these field names staying the way they currently are.

So what would I do to meet the requirements listed in my first post?