Comparing Promotion Requirements with courses

[Ahmad_3011]

Hello,
The database attached a sample for a promotion system from the EMP form when you choose promotion needed to an employees the access should compare the Promotion Requirements with the courses taken by the employee, every promotion has a mandatory courses and optional courses, all mandatory has to be completed and at least the number of optional courses for the promotion and if courses taken not matched with courses the access highlights the missed courses or any other notification
thanks

 

[Ahmad_3011]

Are there any ideas

 

[Ahmad_3011]

Can someone help with this

 

[JHB]

Could you show what result you want, from the data/form you have in the database?