listbox connections and alternate states

[Anonymous]

hi,

my problem is:

table a >> listbox a

table b >> listbox b

listbox c >> both table a and table b

how can I connect them like that?

it seems impossible because you can choose only one alternate state for one table.

PLEASE HELP.

thanks.

[Anonymous]

Yes! Andrew I was talking about that!

I am using alternate states to do that,

But for List C how can we do it? because you can choose only one alternate state

[Anonymous]

Jonathan thanks,

but ı was making it with alternate states,

for ex. if ı want one list box to effect only table a but not table b, I give different alternate states to them.

but this causes the above problem, when you make a third alternate state to effect both tables, it is impossible

[Anonymous]

A possible option could be to define two triggers.

1. On selection of List A field in Alt state1, should also select List C field in Alt State 3

2. On selection of List B field in Alt state2, should also select List C field in Alt State 3

Net result would be any selection in Alt State1 or 2 will also select the same value in Alt State 3. Hope it helps.

[#5]

I am not sure I got this right. the below will give you three tables. Based on the data you have given, I have created two inline tables and the third is derived.thus, the resident source base.

According to your illustration you only need the day in the box and to link.

I hope this helps. Please let me know

Table1:

LOAD * Inline [

name,day,value

a ,20150501,10

b ,20150502,20

a,20150502,15

c,20150503,25

];

Table2:

LOAD * Inline [

name1,day,value1

d ,20150501,10

e ,20150502,20

e,20150502,15

f,20150503,25

];

table3:

load

Distinct

day

resident Table1;