I am trying to use a sql query in the apex to populate a field which is based on another fields value, so I want used to input EmployeeID and it should Populate Name and Birth Date
I thought of creating a dynamic action to populate name and birthdate based on ID
On click event of Item "Name" and true action " set value" the set type is sql statement
select Name from tableX where EmployeeID=:P2_EMPID
but I am not getting anything on the form.
I did the same thing for Birthdate but No value is being displayed on the form when I click the checkboxex.
What am I doing wrong?
Thanks,
Blyzz