How do I set up a reservation table

[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

 

[Geof Wyght]

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.

 

[Jim Davenport]

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

Take a look at
http://www.webshipments.com/schedule
OR http://www.webshipments.com
Under Resource Reservations....

Not as trivial as it may seem....