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

Problem with onObjectValidate on a Related Field

onobjectvalidate related field

  • Please log in to reply
20 replies to this topic

#21 LaRetta   Lifelong FM Student

LaRetta
  • Members
  • 9,791 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Time Online: 218d 10h 36m 12s

Posted 29 January 2014 - 06:09 PM

in reality, the serial number is unique to every box that we have built, therefore, the boxes table currently contains about 900 entries.  Is it unreasonable use a value list that large?

 

Value Lists, even if using pop-up menus and drop-down lists, work best for sets under 50.  Since this is a LineItems portal on an Invoice, I would probably include another field such as Model which can filter the list for you.  If you first select the Model, you can use conditional value list to then display only boxes for the model specified. 

 

Another option is to provide a portal in a popover or window.  You can filter the portal in similar fashion.


  • 0
Each assumption is an educated guess, a likely condition or event, presumed known and true in the absence of absolute certainty.





Also tagged with one or more of these keywords: onobjectvalidate, related field

FMForum Advertisers