I would like to perform a lookup from a (choice selection field) on an eform and then select a choice from the oracle database.
All of the choices on the eforms appear to be choices entered into the form itself. I don't want to dupliate data - so I want to select from oracle.
Is there an easy way to do this? If anyone can help me clear this up I would apprecate it. Thank You
This topic has been locked.
3 replies Latest Post - 2010-10-25T11:06:02Z by Greesh_12
Pinned topic eforms - database choice selection
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-10-25T11:06:02Z at 2010-10-25T11:06:02Z by Greesh_12
Re: eforms - database choice selection2009-03-11T17:03:05Z in response to SystemAdminThank you for the information. This is exactly want I wanted to do. I will start to look into the Tokenize piece. Is there any pointers you have to accomplish this?
Basically, I wanted to have a eForm, so when the employee enters their ID, it will populate with their division managers. Here is my query.
select c.fname||' '||c.lname
from dba_table a, dba_table b, dba_table c