for example: In my formA I am having Start button. When clicked need to check empID is in table by using
- Code: Select all
foundset.find()
<somecode>
if(foundset.search())
<do some action>
if foundset.search() returns true, I need to lookup for the empID which department id belongs to. and then lookup for the category for that department. So on
In short for every stage I need to look for some information in table, based on information available need to perform actions and need to relook up table for the information.
Requires suggestions as early as possible.