Row Auto-Select in table

[#1]

Hi,

I have 2 tables that are the same.for example :

store1:
LOAD * INLINE [
    storename, storekey
    st1, 1
    st2, 2
    st3, 3
];

store2:
LOAD * INLINE [
    storename1, storekey1
    st1, 1
    st2, 2
    st3, 3
];

what i'm trying to do is when i select value1 in table1 automatically value2 in table2 gets selected.do i have to use a trigger?how can i do it??

thank you:)

[Anonymous]

Sure it can be done, but it feels like it might be a strange approach. Is there a reason for separating different stores in different tables instead of having them in one?