Connecting Data to multiple columns

[#1]

Hi,

I want to select "Hans" in Leader.

If selected, all possible Seminars shoud be selected too, where "Hans" could be in Leader1, Leader2 or Leader3.

How?

Regards

Michael

[MayilVahanan]

Hi

Use trigger concept

Document properties->trigger

PFA

Hope it helps

[rwunderlich · Accepted solution]

It may make the most sense to simply create a table that links Leadr to SeminarID.

SeminarLeaderLink:

LOAD SeminarID, Leader1 as Leader

RESIDENT Seminar where len(Leader1)>0;

LOAD SeminarID, Leader2 as Leader

RESIDENT Seminar where len(Leader2)>0;

LOAD SeminarID, Leader3 as Leader

RESIDENT Seminar where len(Leader3)>0;

See attached.

-Rob