ACL on reference field not working?

[SandyL83]

Hello, I am trying to set up an ACL on the cost_plan table. Basically, only people with a certain role should be able to edit any field on the cost plan after a demand moves into specific states. I set up the following ACL on the cost_plan table: Role - demand_screener (then I also have a script to account for the demand state) Type: Record Operation: write Name: cost_plan, * (so the * should apply to the whole table) When I apply the ACL, it seems to work except for on the reference fields that are on the cost plan table. There is a Start Fiscal period field (and that pulls from another table). This is editable to non demand screeners (and shouldn't be based on the ACL). Any idea how i would apply the acl to the reference fields? If I put the acl on that actual table, i can't put the proper filter conditions on it (i can't link it back to the demand table states). Any help would be appreciated thanks!

[asifnoor]

Hi,

There could be a field level acl which might be giving the access to edit. Field level ACLs are given priority only wild card ACL. 

If not, then create a field level ACL for the reference field and add yoru code there and then it will work.

Mark the comment as a correct answer and also helpful if this has answered your question.

[SandyL83]

Thank you for the feedback. I did try that, and it's not working. I also don't see any other ACLs on these fields. I will keep looking, but i do appreciate your feedback. 

[asifnoor]

Enable acl debug and then inspect your reference field and check. It will tell you which ACL is giving you write access.