I would like to know if there is a way to use two fields for security. I want two people to be able to view and see this data but only those two people. Only "Admin" will be able to see everything.
I have a situation where one person will initiate/create a record. Next, a person will be assigned to do followup data entry for this record. The first person will need to see who and what followup has been done on this record. The second person will have to find out what has been assigned to him and update the information. I believe I could do this with a report but I would like them to be able to click on a "View" to see all the data in the record.