Default additional selections

[#1]

Hi guys,

Need a solution to the following requirement

Given the below set of value

Type, Name

1     A

2     B

3     C   

4     D

5     E

On selecting 1 in a list box, Type should take in values 1 and 4 i.e. 4 need to be the additional selected value in every case, no matter what the selection is made in Type.

Selected value 2 should also reflect Type = (2,4) as Current selection.

Same goes for Name i.e Selected value B should also reflect Name = (B,D) as Current selection.

Thanks

[Roop · Accepted solution]

Create 2 sets of data with similar values as per the portion of script below and then set a document action to calculate the field W2 as V2 plus the content "D" as the image shows.

I set up the following and changed W1 from V1.

NewV:

Load * Inline [

V1, V2

1,A

2,B

3,C

4,D

5,E

];

NewW:

Load * Inline [

W1, W2

1,A

2,B

3,C

4,D

5,E

];

and then under document properties set up the new values as per the image attached. This adds "D" to the values already selected.

Hope this helps

[#3]

It works.. (Y)

Thanks Rupert

[Roop]

Please mark as correct

Thanks

[Greg_Hood]

Another option to use in your trigger, which works with your specific example is to use "select possible".  See attached, that will select all possible values available after selecting a Type.