Hide specific records from view
Can anyone help me hide specified records from specific users using admin rights or any other way?
If you have a condition that describes the records that the user can see, such as CreatedName = AccountName then you can specify that in File - Manage - Security - Privilege Sets. You can choose what records each user in that privilege set can see in each table.
See "Editing record access privileges" in FileMaker Help and check out this particular sub section: "Entering a formula for limiting access on a record-by-record basis" for a detailed description of how to set this up.
Retrieving data ...