user2626293 wrote:Hi Srinivas
I have simple find form, this has two fields ENAME and DEPTNO, Here a single employee is attached to multiple departments, so based on the ENAME the LOV of the DEPTNO will be made available, and user will choose the appropriate value of the record and he clicks on the FIND button.
Once he clicks the FIND button it will display the records in an another Window.
Here the Condition is the user can enter only employee name and click on the find button, but if he chooses the DEPTNO and clicks on find it will throw and message saying please enter a valid ENAME.
I have a scenario where i am facing a problem, first the user gives ENAME and the DEPTNO, and then before clicking on the FIND button he goes and delets the ENAME and directly clicks on the FIND button, he my trigger is not firing, and all the records are being queried.
And he wants both the fields to be Optional. Please Advice.