Account access based on specific field entry
I want to assign records to specific representatives so that when they log into their account (via web browser) they see a list of ONLY their assigned records. They will then have full access to those records and NO access to any others.
So where do I start with that? I currently have it set up as a drop-down box with the 10 representatives' names to choose from as I create the records. Could I write a script that would only show records where their name was chosen as the representative? And would that require a different privilege set for every user?
I think it goes without saying that I'm a complete newbie here :(