Jump to content

  •  

Photo

valuelist based on record


  • Please log in to reply
3 replies to this topic

#1 Kip  novice

Kip
  • Members
  • 76 posts
  • FM Application:12 Advance
  • Platform:Mac OS X Mountain Lion
  • Skill Level:Novice
  • Time Online: 2h 32m 24s

Posted 23 July 2014 - 01:22 PM

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
A problem is merely a state of mind you don't want be in too often.

#2 ggt667  newbie

ggt667
  • Members
  • 61 posts
  • LocationTellus
  • FM Application:11 Advance
  • Platform:Cross Platform
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 19h 14m 15s

Posted 24 July 2014 - 12:12 AM

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

Co-author: FX.php, pyFileMaker, netatalk, +++

 

http://wethecomputer...t.blogspot.com/


#3 eos  Paris 2016 … :-)

eos
  • Members
  • 1,175 posts
  • LocationTegernsee, Bavaria
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 222d 13h 22m 3s

Posted 24 July 2014 - 06:37 AM

See if this helps you:

Attached Files


  • 0

#4 Kip  novice

Kip
  • Members
  • 76 posts
  • FM Application:12 Advance
  • Platform:Mac OS X Mountain Lion
  • Skill Level:Novice
  • Time Online: 2h 32m 24s

Posted 24 July 2014 - 06:17 PM

hi eos,

 

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


  • 0
A problem is merely a state of mind you don't want be in too often.




FMForum Advertisers