Friday, May 19, 2006

How to auto-populate a field?

create a user-user data field called "department" with a validation of "KNTA-Department-Enabled"
give it a token called "DEPT"
the column relating to this token is USER_DATA1
create a rule called "Auto-fill_dept"
the sql behind the rule will be:
SELECT USER_DATA1, VISIBLE_USER_DATA1
FROM KNTA_USERS
WHERE USER_ID = [SYS.USER_ID]
The results will be:
[REQ.DEPARTMENT_CODE] and [REQ.DEPARTMENT_NAME]

0 Comments:

Post a Comment

<< Home