Restriction data by sheet

[#1]

Hello,

I would like to implement a restriction data by sheet on my application.

Suppose I have a table country:

Country:

France,

Espagne,

Belgique,

Suède

On The sheet 1, I would just give the access to France and Espagne.

And especially to allow the user to choose between France and Espagne in a list box.

And on the sheet 2, I want to give access to all countries.

I locked the selections in the Field Country, the user can not select from France and Espagne.

Any advice is welcome

[Gysbert_Wassenaar]

If you're using QV11 you can use alternate states to achieve this. Create a new alternate state and assign it to the second sheet. See attached qvw

[#3]

Thank you for your answer,

I already use alternate state to achieve this. The problem is that the alternate state is also cleared out when I cliked on "clear all" button.

what I really want to do is :

- On a specific sheet, allow the user to have access only to France and Espagne and

allow him to select "France" or "Espagne" (in a list box)

- On another sheet, give the access to all the countries to the user.

[Gysbert_Wassenaar]

Ok, that needs a bit more trickery. See attached qvw. I think it's necessary to add another field with the regions (countries in your case) that can be used to restrict the values on. That field will be locked to the restricted values.

[#5]

Yes it's excately what I needed

I'll give it a try and i'll let you know

Tnx