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...