Section access from table with two fields

[Anonymous]

Hi All,

I'm trying to restrict users to only certain cost centres, and so have used the following.

this works until I try to add a section field, Expense Category, which is need to restrict some users to see all cost centres but only the training expense category.

The file looks like this, where the F codes are then used in the access tab.

Any ideas why this doesn't work with * in exp cat column apart from when training?

thanks!

[kaushiknsolanki]

Hi,

Check this link.

Data Reduction Using Multiple Fields

Section Access with multiple fields

Basics for complex authorization

Regards,

Kaushik Solanki

[Peter_Cammaert]

It shouldn' work at all, as the Section Access table has a field called "DATA_GROUP_Cost_Manager" that will be automatically renamed to "DATA_GROUP_COST_MANAGER" and all field values will be converted to upper case (standard Section Access behavior). But there is no such field in Section Application...