AnsweredAssumed Answered

Limit View by value but not global variable

Question asked by DanielShanahan on Jun 5, 2015
Latest reply on Jun 8, 2015 by disabled_jackrodgers

Mac Yosemite

FileMaker Pro Advanced 13.0v5


I set up a privilege set to limit a user's access to records.  The user can only see records s/he created.  There's nothing really special about the calculation or the opening scripts and subscripts (which are all set to fun with Full Access).


My problem is that it doesn't work with a global variable.  It works when I hard code the value but that's hardly helpful.


See image 01_SeeOnlyMine_Security for the calculation.


This works-

Records can be viewed when:

InspectorID = 3


This does not-

Records can be viewed when:

InspectorID = GetAsNumber ( $$InspectorID )


Nor does this-

Records can be viewed when:

InspectorID = $$InspectorID


PROJECT::inspectorID is a number field.  No auto-calculations or lookups.


See image 02_SeeOnlyMine_LoggedIn to see the AccountPrivilegeSetName and $$inspectorID.  Even though $$inspectorID=3, "Records can be viewed when:" does not evaluate as True.


Any thoughts?