How to control the data to display for every users?
Hello Experts,
Im creating a module in ORACLE forms6i and I want to control all the data to display for every USERs. I have 1 Table and it has 5 columns.
My module has 5 columns and 5 rows of records to display.
Problems:
For USER1, I want to display all DATA in column3 and column4 only and all remaining columns shoud be null.
For USER2 , I want to dislplay all data in Column1 only and all remaining columns should be null.
How can i control all the data to display for each columns? Can you help me please. Im using the Clear_Items but its not working only the first row are null but the remaining
rows has its records.
Thanks.
Lala