Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi
Use trigger concept
Document properties->trigger
PFA
Hope it helps
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