select a listbox value based on othe other listbox selection

[psankepalli]

Hello Experts,

Could you please help me to achieve the below requirement for my project

see the attached file

I have two  filters Universe & Dose. Each filter having two list boxes , Universe (Desc 1, Desc1 DET), Dose (Desc 2, Desc2 DET). I want to achieve the below requirement from the attached POC.

Universe	Dose
SUMMARY – TOTAL	SUMMARY – TOTAL
DETAIL – PUBLIC	SUMMARY – TOTAL
DETAIL – PUBLIC & PRIVATE	SUMMARY – TOTAL
DETAIL – PRIVATE	DETAIL – DOSES

Thanks in advance

San

[ecolomer]

See this example

[psankepalli]

Hi Colomer,

     Thank you for your reply, but my requirement is I need to select the different value based on the First listbox selection not the same value.

Thanks

San

[Qrishna]

which one one do you want?

Do you want to achieve the table in the grid or

select a listbox value based on othe other listbox selection ?

[psankepalli]

Hi Krishna,

     Yes, I want to achive that table. Let me know if you have any other questions

Thanks

San

[Qrishna]

Hi Prasanna,

You may find the script a bit tricky.

But thats one of the way u can choose to achieve the table in the grid as per your requirement.

and make sure you use the data as is which you've provided me in your attachment.

let me know if you find any difficulty.

Thanks

[psankepalli]

Hello Everyone, Thank you for your response.

I am able to achieve my requirement with the help of Triggers.

Here are the steps for reference

Document Settings -> Field Event Triggers -> [Desc 1 DET] On Select

Add Actions -> Add -> Selection -> Select In Field.

Field: [Desc 2]

Search String:

=if(GetFieldSelections([Desc1 DET])='PRIVATE','DETAIL','SUMMARY')

Thanks

San

[Qrishna]

You said you wanted to achieve the table in the grid?

[psankepalli]

Sorry for the confusion caused by me, I want to achive that listbox selection. Thanks you for your response.