User Access for Certain Records
I have a database that I set up and I am trying to figure out how to give users to only certain records. I want to allow all users to view everything, but only certain users to be able to edit certain records. For example I have a "location" field set up and I want a group of users to be able to edit records containing one location but not records for another location. I am thinking this needs to be a start up script, but not sure how it would work. Can anyone help me?