Could you create a View or Vendor form linked to the external SQL data, and have the table field populate from that?
Rick On 10/16/07, Andrew Hicox <[EMAIL PROTECTED]> wrote: > > 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"
