N
N.Molderf
Guest
I have two tables first its candidates and second this is employee. Before when i add new employee i have to look up in candidates table and after that take candidateID and add new employee with this key. I dont know how to look up in this candidate tabel. For now i have this but this is bad solution.
set cfname label "First #"
clname label "Last #" with overlay title "Candidate Name" 1 columns row 5 column 28.
find last candidates where firstname = cfname and lastname = clname no-lock no-error .
I want scrolling them and when i press "Enter" i take this key and add in employee table.
create employee no-error.
Assign
employee.candidateid = id
employee.employeeid = next-value(employee)
hiredate = today.
I dont know how to achive this.
Continue reading...
set cfname label "First #"
clname label "Last #" with overlay title "Candidate Name" 1 columns row 5 column 28.
find last candidates where firstname = cfname and lastname = clname no-lock no-error .
I want scrolling them and when i press "Enter" i take this key and add in employee table.
create employee no-error.
Assign
employee.candidateid = id
employee.employeeid = next-value(employee)
hiredate = today.
I dont know how to achive this.
Continue reading...