Use trigger to select text values in one field based on text values in another

[#1]

How to get F3 values selected based on F1?

In F1 value C is selected , then in F3  TEXT3 should be highlighted green?

Thanks

[sunny_talwar]

May be like attached

[#3]

Sorry but without F2.  F1 value A selected gives F3 TEXT1.

Thanks.

[sunny_talwar]

How would I know which F1 is related to which F3? What's the relation between the two?

[#5]

Hi ,

Relation is sequential order they appear 1 to 1.

F1                  F3

A     --->       TEXT1

B     --->       TEXT2

C     --->       TEXT3

D     --->       TEXT4

E     --->       TEXT5

Thanks.

[sunny_talwar]

Then why not create a relation between them in the script

Data1:

LOAD RowNo() as Key,

F1;

LOAD * INLINE [

    F1

    A

    B

    C

    D

    E

    F

    G

    H

    I

    J

    K

    L

];

Data2:

LOAD RowNo() as Key,

F3;

LOAD * INLINE [

    F3

  TEXT1

    TEXT2

    TEXT3

    TEXT4

    TEXT5

    TEXT6

    TEXT7

    TEXT8

    TEXT9

    TEXT10

    TEXT11

    TEXT12

];

[#7]

Actually not 1 to 1 key should be removed....  What I'm trying to build is a simple questionnaire.

If user selects Q1 then automatically pertinent criteria gets selected from the fields user does't have to worry about it.

For example. If user selects Q1 then it should trigger say Option1 'TEXT5' and Option2 'TEXT12. Sounds simple enough. If it has to be hard-coded that is fine.

Thanks.

[sunny_talwar]

I am not sure I follow....How are you selecting TEXT5 and TEXT12 from Q1?

[#9]

Image attached.

I need the above to occur only when I click Q1. It should highlight OPTION1 'TEXT5' and OPTION2 'TEXT12'

Buttons added for demo purposes only.

Thanks,

[sunny_talwar]

So you only need this for Q1, rest of the selections in Questions won't select anything?? This is just needed for Q1?