situation;

Two accounts and a privilege to limit the records access.

if i ask for a complete list or omitted records i get all the records, part of the records are accessable and part no.

then the question is:

How to get only the complete list and relative omitted accessable records?

By

Franco

I am not sure if this may be possible unless one uses a scripted find method.

Perhaps you can store the number of records that that user has access to each time as part of your scripted find process. Then when you have additional criteria to find find, you can take it from the total of that user's accessible record count.

actually i use the find metod, the question is: if the records are not accesible why filemaker show those records, do exist other automatic way to get the right records without the script metod?

When using a show all, it will display all the records. The records that the user does not have access to will display with "".

I have not tested this but try this. Create a summary field that COUNTS the number of records. Then create a self join of the table using a cartesian join ('X' operator ). Then reference the related summary field from that self join table occurrence. I would think that it should return the total number of records that user has access to regardless of their found set.

i will test.

many thank for your attention.