Check if one value is in all tables or in one table.

[Geir Hogstad]

Hi,

I have found a solution here, but I have a feeling that there is abetter solution.

Goeal, to see if an employee have passed all 3 trainings, or one of them. 

Ja=Yes, Nei=No.

Example atytached.

Best Regards

- Geir

[#2 · Accepted solution]

@Geir Hogstad 

Less elegant, but shorter:

[#3]

@Geir Hogstad 

A similar problem was discussed in this video today:

https://www.youtube.com/watch?v=kjeR7nZ3Clw

[#4]

Thank you Hans, a good silution.

/Geir

[#5]

Thank you, I will have a look. Always good to learn.

/Geir