Time

[Loi]

Hi,

I have a database which keeps track department equipment.
The problem is :

For example:
A reserves Proxima # 2 on 5/10/04 from 10:00 a.m to 3:00pm.
--------------

B also reserves Proxima # 2 on 5/10/04 from 7:00 to 4:00pm.
-----------

A is a person should use the Proxima #2 because he
reserved it first. However, B used it because she came to
work early on 5/10/04 and took out Proxima and used it
until 4:00pm.

There is a way so I can stop people use a equipment which
has been reserved by one else already.

For example: It will pop up a message like " the Proxima
#2 been reserved by A " when B enter date and time to
borrow Proxima # 2.

Thank you very much
Loi

 

[Guest]

consider adding one more field to your table
with time type

each time a reservation was made stamp the transaction
with time (time the record was saved)

in this case, you can determine which from A and B makes
the reservation first.

so when B is making reservation, if date is the same, then
check which time is earlier ...