This is possible. Two different approaches.
1. If you want to just logically associate the fields without actually selecting in the second table, use the "data island" approach (search the forum if you're not familar with it).
2. If you want to make an actual selection in table two, use an action as discussed in this thread.
thanks for these good two advices.
I like the second option that you proposed quite well. But somehow it will not works !
I want to click on a blue highlighted value and want a automatic selection to the SID Table.
Unfortunately, I cant link the (green) fields with a key, because otherwise I risk a circular reference.
Can you please have a look out my example qvw ?
Thank you very much !