Ok I am attempting to build a training database that records the
employees training required vs. training received. My problem lies in
the fact that the jobcode(s) assigned to that employee determines what
training is required. I need to have a form that 'checks' a
employee/jobcode table(which contains a jobcodenum field and a
employeenum field) to make sure that employee is required to take that
course. for example:
when I press a cmd button
check employee/jobcode table to see if a record exists
if not then show a messagebox that says "this employee is not
required to take this course"
if true then write a record to the training received table
Is this possible?
