Jump to content

room reservation


This topic is 6454 days old. Please don't post here. Open a new topic instead.

Recommended Posts

hi. i do not know if this is the right place to post this. anyway, i hope someone helps.

i have a database with two tables.

table 1 = rooms

table 2 = reservations

table one contains room numbers and details about the room.

tabel two contains names of guests and in date and out date. the two tables are related.

what i am trying to achieve is that when i input a date on table two it checks if the room is available on that date timeframe or not, and promts me. any example how to do this? thanks.

Link to comment
Share on other sites

Take a look at this tread, and the file by: CobaltSky Here it was done in v5 format, but you should be able to convert it to v8 okay.

The Subject is [color:blue]A little help about dates...please? and is quite lengthly, but is worth the read.

HTH

Lee

Link to comment
Share on other sites

This topic is 6454 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.