Hi Everyone:
I have a situation where I need to show records from an external non-
ARS database in a table field.
We have an external Oracle database that contains customer POC
information. Because our remedy backend is also an Oracle database,
we simply have a DB link to the external database inside the ARSystem
tablespace. This works fine in most all circumstances, when we need
data from the external database, we can select it over the database
link from an SQL setfields action.
However, now I have a situation where I need to display a list of
customer POCs and have a user pick one. The natural thing seems to be
to display the POC records in a table field, and have the user click
one. But I can't figure out how to do this.
The only thing I can think of is to have an active link fire off an
SQL setfields and use the "if multiple records match,, display list"
option. But that's not really the behavior I'm after, as the results
list pops up in a separate window, and that's going to confuse the
user, etc. What I want is a list of those records in a table field.
So ... has anyone out there in Remedy-land finagled some shim-sham
like this before?
let me know,
thanks,
-Andrew
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
