Sign in to follow this  
Followers 0

valuelist based on record

4 posts in this topic

Posted

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!

 

0

Share this post


Link to post
Share on other sites

Posted

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

0

Share this post


Link to post
Share on other sites

Posted

See if this helps you:

RoomsByDate_eos.fmp12.zip

0

Share this post


Link to post
Share on other sites

Posted

hi eos,

 

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

0

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  
Followers 0