Dear expert !
I am working HR dept. and we have govt. approval visa and permission for hire worker from 11 countries. A visa numbers have different work category and defferent country workers.
example : VisaNumbers 1029450
in this visa numbers have || 5 category visa || total visa 29 Visa's || 4 Country selected||
After that we selected workers and give same country a agency authorise for stamp visa in the worker passport.
Example : after review CV we selected worker Mr. Jhone from USA. Agency also USA.
So, I want show Enter Visa Numbers give me result as:
How much visa we Authurised to agency
Authurised which country name ?
How much visa we have still balance ?
and which category is balance ?
But i dont know how to work this ? any help will be apprecite.
Regards