I have four tables employee,applicant,employee qualifications,applicant qualifications.
once if we click the button all the information from applicant should be converted into employee.this is working fine.
see,employee qualification is a dependent of employee i.e foreignkey relation ship…similarly with applicant and applicant qualification…
now what we required is when we click on button not only the information in the applicant card is converted but also the applicant qualification should go into the employee qualification.
I am pasting the piece of code::
IF NOT CONFIRM (‘Do you want to convert into employee’) THEN
IF “Candidate Status” = “Candidate Status”::Selected THEN
glbrecemp.SETRANGE(glbrecemp.“applicant id”,“Applicant Id”);
IF glbrecemp.ISEMPTY THEN
glbrecemp.“applicant id”:=“Applicant Id” ;
glbrecemp.SETRANGE(glbrecemp.“applicant id”,glbrecappqual.“Applicant ID”);
UNTIL NEXT =0;
ERROR(‘Only Selected Candidates can be converted into Employees’) ;
please help it out …