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?