Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


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
  • 44 posts
  • LocationTellus
  • FM Application:11 Advance
  • Platform:Cross Platform
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 15h 1m 48s

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,027 posts
  • LocationTegernsee, Bavaria
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 203d 20h 36m 23s

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