Page 1 of 1

Managing dependent columns in a roster

Posted: September 20th, 2018, 7:48 am
by Gillesbop
Hello to members of this group

I designed the app that is attached to this post of which 6 columns are 2 to 2 highly dependent
So in the roster we have: culture 1 and Production 1 are dependent. Same for culture 2 and production 2 as well as culture 3 and production 3.

So here's what I'd like to do, but I can't do it:

On one line, each time the column (culture 1) is filled and culture 2 and 3 are empty, production 1 must be filled and production 2 and 3 are skipped and then we go to the next line?

And if culture 1 and 2 are filled and 3 is empty, Production 1 and 2 must also be entered and the cursor jumps to production 3 for the next line

Could you help me do that, please? In case you do not understand me, I will explain myself.

Thank you !

Re: Managing dependent columns in a roster

Posted: September 20th, 2018, 2:41 pm
by Gregory Martin
I can't open the file since 7-Zip says it's corrupt. However, in general you could write code like this:
PROC PRODUCTION_2

preproc

    ask if CULTURE_2 <> notappl;

PROC PRODUCTION_3

preproc

    ask if CULTURE_3 <> notappl;

Re: Managing dependent columns in a roster

Posted: September 20th, 2018, 3:39 pm
by Gillesbop
Ok, thanks Gregory !

Try to open the file with CSPro 7.1 because I designed it with the last one after unzip it!

Anyway I'll try your proposition.

Thank you again !