distinct text from 3 tables

[wunderch]

Hello,

I have a .qvw with 3 tables. For example:

Table1:

Tour	Driver 1	Qualification
10	Peter	A, B, C

Table2:

Tour	Driver 2	Qualification
10	Paul	C, D

Table3:

Tour	Driver 3	Qualification
10	John	A, B

My Problem is:

When i select Tour 10, then i want to show in a listbox or a diagramm the result of Qualification from all Drivers

Tour	Qualification
10	A, B, C, D

Can anybody help me?

Thanks

Chris

[wunderch]

GREAT!!

Here are the two .qvd.

ZQUA_TESTCW.qvd and TOUR_Ebene2.qvd

[Jason_Michaelides]

Sorry for the delay - my internet went down!

Here you go - see attached.  I have commented the script so hopefully you'll follow the logic.

Hope it helps,

Jason

[wunderch]

Hi Jason,

no Problem!

I could follow your comments and it works fantastic.

Thanks for your quick help!!

Chris