4.04 SQL View - Setting

01. Click Tools | Maintain DIY.

02. Click New View Template.

03. Select Maintain Employee & Click OK.

04. Click New.

05. Enter the Description.

06. In Filter Tab Click press the button add a new condition

07. Click on the Green Font & Select Code

08. Click on the Brown Font & Select equals & Enter Example '003'

09. Click Show Text

10. Click Save & Close the windows

11. Select the Record created just now at DIY View Template & Select OK

12. Right Click at View Template you just created & Select User View (for User View)/ Browse View (For Browse View)

13. Assign the View Template to user you wanted to set to by tick on User View & Click Save. (for User View)

14. Assign the View Template to user you wanted to set to by tick Default & Click Save. (for Browse View)

Related Topic https://sites.google.com/site/sqlestream/sql-payroll/4-system-sql-payroll/4-09-sql-view---user-view-vs-browse-view