Display training course does not join yet.

Hello, I have 2 tables: Training frame and training data. 

Training data: training history of trainees.

 

/ Training frame : Define level of courses

Employee need to study all course based on their position from level A to level D. Note: Level of course and level of band is same.

Ex: Employee E1 band A, so he needs to study all course A1 → A5 and for promotion to band B, he also needs to study all course B level. When I use filter, expect result as below:  

1. Display table with all course completed and need to study.

2. Also, display external course if already completed

3. Index dynamic based on filter

Link sample here: Training data sample 

Please help me resolve this issue. Thank you so much.