Automate

Hello

I have a repeating table whose values comes as drop-down list (data connection = reference data). 

In this drop-down list I have a list of possible units.

If the user chose in line 1 for ex. unit = PAL it should be not allowed to use the same value in line 2 from the repeating table.

How can I avoid double values?

Thanks in advance.

Jana

Hi Jana

One way is to use a validation rule and use an IF statement on what you want to be Unique  For example,: if material description is not unique, like:

Then display a message about it.

HTH,

Sigrid

Hello

I have a repeating table whose values comes as drop-down list (data connection = reference data). 

In this drop-down list I have a list of possible units.

If the user chose in line 1 for ex. unit = PAL it should be not allowed to use the same value in line 2 from the repeating table.

How can I avoid double values?

Thanks in advance.

Jana