MS Access: How to prevent from booking one room in few times for one date

Question

I have simple database. It contains 2 tables.

Rooms
Reservations

They is relations via room ID. How can I prevent in Reservation table to do not make a reservation for one room in the same date?

score 0 · Answer 1 · answered Feb 06 '23 at 15:22

0

you can insert an unique constraint on fields (roomID and reservationDate). In this way you'll can have only a reservation for a room in a date. If you want to unlock a room, you'll have to delete a reservation row.

answered Feb 06 '23 at 15:22

Paolino L Angeletti

162
10

Ok, but how to set it? – Hubert S Feb 06 '23 at 16:57
1

you can retrieve the information for add a new constraint in this link: https://stackoverflow.com/questions/5635811/unique-constraint-on-multiple-fields-in-access-2003 – Paolino L Angeletti Feb 07 '23 at 09:43

MS Access: How to prevent from booking one room in few times for one date

1 Answers1