3 Replies Latest reply on Jul 10, 2014 2:28 PM by nexicobob

    How to set “limited” security access in Filemaker for a related table using PHP access

    nexicobob

      Title

      How to set “limited” security access in Filemaker for a related table using PHP access

      Post

                I am accessing Filemaker tables through PHP

                In Filemaker I want to limit access to records in table A

                Table A has two fields: Login Name and Group ID

                For Table A, I set the record level security to “limited” and the (Records can be viewed when) condition to: “get(AccountName) = Login Name” This works well.

                Table B has two fields: Group ID and Group Name

                Now I want to set the access for records in Table B where Table A::Group ID = Table B::Group ID

                How do I set the "limited" Boolean condition for Table B?

                Thanks in advance for your help.