Jump to content

valuelist based on record


Kip

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

Recommended Posts

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!

 

Link to comment
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

Link to comment
Share on other sites

This topic is 3535 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.