selecting a field

[#1]

hi ,

i have 2 list boxes.

in one list box with LED style i have two values named as

1. Blue

2. Black

and in another list box and i have the values as

1. IND

2. AFR

3. COC

4. HYD

IND and AFR are from Blue company and COC and HYD from Black

so when i click on IND as it is related to blue , the first list box whiich i ahve blue also should get hightlighted. when i click on HYD , black has to hightlight.

please help.

[adamdavi3s]

If you want to actually select the item in the other listbox then you can use a field trigger, i will do an example

[stabben23]

Hi,

It's all about datamodeling, these 2 tables must be Connected to each other With a keyfield.

How doesYour datamodel looks like?

[adamdavi3s]

Look at settings> document properties > triggers > field event triggers

This will only work when one val is selected, not multiple.

[robert_mika]

Is there any association between those two fields?

How does your data model look like?

If you are saying that:

IND and AFR are from Blue company and COC and HYD from Black

How do you know that?

Another way would be to use Mapping load in script level to associate both of those fields:

Don't join - use Applymap instead

[adamdavi3s]

^ these are both valid, did I take 'highlight' too literally?

Even if the two are linked, selecting one won't select (and therefore highlight) the other.

I started with the assumption that the two were already related / linked and the selection was key

[MarcoWedel]

Hi,

maybe another solution could be:

LOAD * Inline [
Company, Code
Blue, AFR
Blue, IND
Black, COC
Black, HYD
];

hope this helps

regards

Marco