1. Section access is always at a document level, meaning you code it in the document script, and meaning that you may have two documents with different section access. Search a bit in the forums and you will find several dozens of posts and sample codes covering the different fields and ways to get the section access working.
2. I don't have such setting. What version are you using? Can you please elaborate on how to get to that "Advanced" tab?
you may define a section access in your script as
ACCESS, USERID, [PASSWORD, FIELD1, FIELD2...]
Admin, Name, [pwd, Dept, field...]
User, Name, [pwd, Dept, field...]
you can ever load it from a table or a file as
'USER' as ACCESS,
Name as USERID,
Pass as PASSWORD,
Dept_name as DEPT
Don't forget to save a copy beifre loading in case you messed up the content of this section, you wouldn't be able to open it again!!
open the your section application and get relation with access table
star is *;
load * inline [
Territorycode as DEPT,
this will give all access to DEPT = 0 and reduce date to other accordiing value of DEPT.
Tick the option "Data reduction based on section access" in "Setting, opening"