multiple field level security

[tom murphy]

i have an instance where i need to have the same field secured differently for different users based on a specific record. i do not see any way to do that. i can restrict the whole record by setting the security but not setting different security for a user for a single field. any suggestions?

[Steven H. Blackwell]

Restrict it to do what? or for what? Different Accounts can have different privileges set for them by defining different Privilege Sets.

Steven

[tom murphy]

yea i understand that. what i want is different users to be able to update different fields on the same record based on their signon.

for example for user1.

if field1 has an "M" in it

user 1 can modify field 2

field 3

user 1 can view rest of fields

if field 1 does not have an "M'

user can can view all fields only

[Steven H. Blackwell]

Well in the field definition validation options you need to define a calculation that addresses the tests you want to employ. Typically this would be a Case function with each paired result return a 0 or a 1. If it is 0, modification isn't allowed; if 1, it is.

Steven