Page 1 of 1

Restricting the values ​​of one value set according to another

Posted: November 23rd, 2017, 5:51 am
by Gillesbop
Hello everyone,

By designing a data entry, I'm faced with a little problem, here's how it looks:
I have two items whose value set of the first depend strongly on the second (the Excel table and the two images attached on : http://www.cjoint.com/c/GKxkXl2E5JC in the ".rar" file will allow you to see more clearly) .

What I want to do is that each time I write the "value set" of the first item, the cursor moves to the second item
makes me only accessible the values ​​depending on the first "item" that I chose and hides the "value set" that have nothing to do with it.

It seems a little difficult even explaining. But the Excel file and the 2 pictures will allow you to see better.

Thank you in advance for helping me.

Re: Restricting the values ​​of one value set according to another

Posted: November 23rd, 2017, 6:49 am
by khurshid.arshad
Dear;

Please see attached file.
Best.
a.

Re: Restricting the values ​​of one value set according to another

Posted: November 24th, 2017, 5:49 am
by Gillesbop
Thank you so much Khurshid

It's exactly what I want.

All the best !