You can use ranges for your where clause. If the ranges is filled with your input it will return data corresponding to your input and if it is empty it will just bring all data from the DB. SELECT *
FROM zemployees
WHERE employeeid IN r_empid[]
...
This cannot be done using events, you actually need to have custom code which will be inside generated PBO of the screen. You should first determine which field to be greyed based on category entered then used below code:LOOP AT SCREEN.
IF screen-n...
