NightWing Enterprises - FileMaker Pro Custom Development

+   Home    About Us    Products    Demos    Resources    FAQs    Orders    Contact   +


NightWing Enterprises — Demo for FileMaker Pro™ 10

Each User Sees a Different Data Subset!

Account-Filtered Records

+   For FileMaker 10   +

As a courtesy to fellow developers and potential clients, the
following demonstration file is provided for free download.

A common requirement for multi-user database systems is an implementation where each user sees only the relevant records - and this is commonly achieved using FileMaker's Record Level Access (RLA) privilege constraint assigned to the Privilege Set associated with the user's login Account. However this still leaves the user looking at a lot of records that display <no access> flags in all the fields. Sometimes this is merely a nuisance, but in many cases it is undesirable.

This demo shows a technique for filtering the displayed records so that different users can navigate through the file performing finds, displaying lists and changing layouts without encountering records that are not meant for their eyes. In addition to RLA settings, the technique harnesses Custom Menus* and Script Triggers to seamlessly transition between user account views, even if provision is made for users to relogin without closing and reopening the solution.

While there are several components to the technique shown in this example (scripts, Privilege settings, OnLayoutLoad script triggers) it can nevertheless be adapted readily for implementation in a variety of solutions and to serve within a range of different scenarios.

This demo file is unlocked and password-free, compliments of NightWing Enterprises. The use of this technique is free for private and educational purposes. Use for business or commercial applications is subject to license (pricing on request).

* To configure Custom Menus in your solution file(s), you will require access to a copy of FileMaker Pro Advanced.

Mac OS X demo download  
Win XP/Vista demo download  

Account-Filtered Records demo for FileMaker Pro

NB: Should you require assistance implementing procedures such as those shown in our
example files, please consider establishing an account with us for developer support.



NightWing Enterprises
ABN 22 207 533 285
PO Box 20, Dallas, Victoria, Australia 3047
Ph +61 3 9016 3347  •   Fax +61 3 9309 8273  •   Mobile 0409 309 143

+   Home    About Us    Products    Demos    Resources    FAQs    Orders    Contact   +

©2001 - 2011 NightWing Enterprises
Please report any problems with this site to:  

NightWing Enterprises - FileMaker Solutions:- NightWing Enterprises, and the internet code-named CobaltSky is an internationally recognized Filemaker consultant, Filemaker developer and provider of Filemaker Pro custom databases, Filemaker Pro custom development, Filemaker Pro custom programmer services and Filemaker Pro custom programming.
Site created and managed using FileMaker™ Pro.

NightWing Enterprises is a division of   d a r k s k y   m e d i a