How do I set up a reservation table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set up a simple reservation table in Access 2000 that will allow a
user to put in a reservation for a particular room (no date) and have have
the user know is his reservation was accepted or that the room is not
available? I only have to do this for 10 possible rooms in this hotel
 
Make a table of roomid, roomdescription. Make a table of
userid, username. Make a crossreference table of roomid,
userid. The user cannot have the room if the particular
roomid - userid is in the cross-reference table already.
Geof.
 
Geof said:
Make a table of roomid, roomdescription. Make a table of
userid, username. Make a crossreference table of roomid,
userid. The user cannot have the room if the particular
roomid - userid is in the cross-reference table already.
Geof.


that will allow a


date) and have have


room is not


in this hotel
Click to expand...
Take a look at
http://www.webshipments.com/schedule
OR http://www.webshipments.com
Under Resource Reservations....

Not as trivial as it may seem....

 
Back
Top