checking availale dates and times

[Nixx1401]

I have a datasheet view form which records visit appointments for inmates. The form has the following fields Date - Date in with the visit form was recorded in the system


Inmate Number
Inmate Name
Invitee Names - an invitee is a person who can accompany a contact on a
visit
Contact Person - the person who the visit is posted to
Date of Appointment - perspective date of appointment. this is done via tele
Time of Appointment - perspective time of appointment.

Is there a way when the date and time is input that checks to verify that this time at that particular day is available and it has not been booked already

My Tables are Inmate Info, Contact, Invitee, and transaction

Inmate Info records the inmate information
Contact table records the contact information
Invitee table records the names of the invitee and the appt time and date
Transaction table records the information from the visit form

[Stingaway]

Yes, but you are going to need to clarify your tables a bit to identify which one actually houses the data that tells what records are already booked and which one is housing the data that is being requested.

If you are comparing data for example from the Invitee table with data from what I would call an appointment request table, then you could use a select query to say if the date and time from the invitee table exist, return a "Nope, you can't do it then" or if it does not exist return a "Yeah man, come on in, the water's fine" or something similar.

It sounds to me that you may need some work on the actual table definition though.