valuelist based on record

[Kip]

Hi,

I've been looking on the forum for this, but i didnt find something that matched my 'problem'

 

I am working on a booking/reservation database for a small hotel. I want to prevent rooms to be double booked.

So what I am trying to figure out is how to create a conditional valuelist based on the information in other records.

Let's say I have a field called: "date booking" with the data "23-07-2014" and a field called: "room name" with is filled in using the conditional valuelist (bullets) and has data "room 1" Now if there's a second ot third booking on the same date 23-07-2014 the valuelist should exclude the rooms already used: so room 1 or any other room is not selectable when already used in another record.

 

How can I do this, or is there a better way?

 

Kip!

 

[ggt667]

It's all a matter of design; I would make a table: RentedRoom,

with the following fields:

 

rentedObject type number

rentedFrom timestamp

rentedTo timestamp

modifiedHost auto-enter timestamp

[eos]

See if this helps you:

RoomsByDate_eos.fmp12.zip

[Kip]

hi eos,

 

That's what I was looking for! Thanks so much!