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.

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

This type of thing has become a LOT easier since version 7, with comparison operators being allowed to define a relationship. See the attached for the basic technique.

DoubleBooking.fp7.zip

thanks for both replies. i will study them.