lock selections for just one user

[kostiskampouris]

Hello everybody.

I have a document with many sheets and users.My goal is to add a new user who can only see one of the sheets (sheet1 )

which after searching I have seen that it is possible(haven't tried it yet).

My problem is that in the sheet1 there are informations about many countries and I want the user to be able to see only informations about his country.

Is there a way to lock the country's listbox with a value but only for the specific user?(I need the other users to be able to navigate through all possible countries and the new user to be able to see only his country) .

Thank you in advance

[sunny_talwar]

Why don't you use section access here?

Introduction to Section Access

[kostiskampouris]

Hello Sunny,once again you gave me the right asnwer and I am really greatfull

After a lot reading about section access I created many examples and all worked fine.

I have a final problem regarding the initial document.The country field as is loaded is an integer

1,2,3 etc .

in the script I use :

Country:

LOAD * INLINE "

country,REGION

1, GREECE

2, CYPRUS

3, ROMANIA

4, NICOSIA (FRANCH)

5, BULGARIA

";

so I can "translate" numbers into names.

In the section access I use :

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, ROMANIA

USER, USER2, U2, BULGARIA

USER, USER3, U3, GREECE

USER, USER4, U4, CYPRUS

USER, USER5, U5, *

];

Section Application;

But when I open the document,all users can see all countries.

Can you see what I am  missing here?

[jonathandienst]

Is the [country] field linked to the rest of the data mode?

have you enabled Strict Exclusion (Document Properties | Opening)?

Also no USER will be able to see NICOSIA (FRANCH) as it is not explicitly listed to any user.

[sunny_talwar]

May be try this

Country:

LOAD country,

     Upper(REGION) as REGION;

LOAD * INLINE "

country,REGION

1, GREECE

2, CYPRUS

3, ROMANIA

4, NICOSIA (FRANCH)

5, BULGARIA

";

so I can "translate" numbers into names.

In the section access I use :

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, ROMANIA

USER, USER2, U2, BULGARIA

USER, USER3, U3, GREECE

USER, USER4, U4, CYPRUS

USER, USER5, U5, *

];

Section Application;

[kostiskampouris]

Thank you for you imidiate answer.

It was the Strict Exclusion that forgot.

Thank you again