tying record(s) to a particular login
Hey Filemaker folks,
How would I go about making sure that when a user logs into FMP, via web portal, that the records assigned to them are the only ones visible.
I have two databases, one contains the investigators name (same as the login name), and the other contains a protocol number which is associated with the investigator, and also associated with one, or several tables of the database.
Ideally, when the user logs in, they will have access, and see only records associated with their protocol number.
Thanks in advance,
Using FMP 13
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 description of how to set this up.