Hi all,
I have a catalog item where I have the fields Requester Name, Requested For (both referencing to sys_user)and Another User(check box). When the catalog form loads, the requester nams autopopulates to the current user. The requested for field only appears when the Another User check box is checked and it needs to be filled up with any user.
Now, I have a select box field "Service" which has some choices which are the same as "u_service" field in the sys_user table. What I want is,
1. If the another user checkbox is unchecked(like when the form has just loaded), the Service field will autopopulate with the u_service field value of the user in Requester name field.
2. If the another user checkbox is checked, the Service field will autopopulate with the u_service field value of the user in Requested For field.
Please help me in doing this.
