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
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 selection2008-07-25T15:17:40ZThis is the accepted answer. This is the accepted answer.So I will answer my own question in case anyone wants to know. The list needs to be tokenized like this <<Tokenize (OrgList,Delimiter)>>
Re: eforms - database choice selection2009-03-11T17:03:05ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
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
Greesh_12 27000165B71 Post