Hello,
This is my table and several data to store Education Requirement.
This is the link - http://i.imgur.com/GZ049Zt.png (Cannot insert, don't know why..)
How to make it the Job Requirement is OR
-2147483648 OR -2147483647
This mean,
Applicant have LevelID=12, StudyFieldID=8 and NO CGPA
OR
Applicant have LevelID=2, StudyFieldID=10 and CGPA between 2.00 - 4.00
is QUALIFY for JobNoticeID=6
SOME CASES MAY BE
Applicant have LevelID=12, StudyFieldID=8 and NO CGPA
AND
Applicant have LevelID=2, StudyFieldID=10 and CGPA between 2.00 - 4.00
is QUALIFY for JobNoticeID=6
Need help to design the screen. As a result, I can combine the 2 record which condition OR and AND
Really need help
Go to the complete details ...