August 13, 201510 yr Newbies Hi All, I'm quite new to FM but have created a database that requires different users to enter data. I would like users to only access the records they have created so need a way of filtering on login and specifying which user is creating the record. I have a user table with unique IDs that is related to my main table. Can this be used in conjunction with the built in account function or is there another way to do this? I'm using FMA14. Thanks Paul
August 13, 201510 yr Read up on this: (Record Level Access) http://www.filemaker.com/help/14/fmp/en/html/passwords.15.15.html#1028797
August 18, 201510 yr Author Newbies Hi Wim, Thanks for pointing me to this. I have managed to do this now. I've created a start up script to perform a find where Record_Created_By = Get(AccountName) which seems to work mostly. Paul
Create an account or sign in to comment