Hi,

I am faced with problem trying to limit amv depth programmatically

based on what was entered in one of the window fields.

Here what I have tried so far:

$INSERT SYSINCLUDE,WINDOW_COMMON%

$INSERT SYSINCLUDE,LCPOSITIONS

$INSERT SYSINCLUDE,WINDOW.CONSTANTS

• DEP.MAX=Maximum depth for associated multi-value prompt sets.

WC_W%(prompt_number)=1

OR

WC_AMV_VARS%=1

WC_RESET%=3

Can get it to work.

TIA

Dave Berkovsky

Maybe a simpler approach is to do something like:

MAXIMUM=WHATEVER

if WC_MV% gt MAXIMUM then data ''

return

Place the above code as a pre prompt on the MV field. Group it with itself too.

J

jb@psi.net.nz

Have you tested this block?

And what would happen if one insert record between existing rows?

You've settled a situation when user adds record in the end of AMV.

View this thread on the forum...