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.