dear gurus!I have a table called courses, another called hr.
Within courses table, I have a field called course and another called requiredCourse and yet another called recommendedCourse and another called posNo.
Then in the hr table, there is a field called posNo (primary key), a key field called positionTitle, fname, lname and hiredate.
What I would like to do is write a code that says give me all the required courses and the name of the employees who are supposed to take thme.
Have they taken the courses?
If the answer is yes, put a checkmark on a checkbox.
If they have not, put an X.
How can I handle this?
Thanks in advance
Within courses table, I have a field called course and another called requiredCourse and yet another called recommendedCourse and another called posNo.
Then in the hr table, there is a field called posNo (primary key), a key field called positionTitle, fname, lname and hiredate.
What I would like to do is write a code that says give me all the required courses and the name of the employees who are supposed to take thme.
Have they taken the courses?
If the answer is yes, put a checkmark on a checkbox.
If they have not, put an X.
How can I handle this?
Thanks in advance