Jump to content
Sign in to follow this  

valuelist based on record

Recommended Posts


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?




Share this post

Link to post
Share on other sites

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

Share this post

Link to post
Share on other sites

hi eos,


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

Share this post

Link to post
Share on other sites

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

Sign in to follow this  


Important Information

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