Or you could even create a view form to that external table. And then create that table field to point to that view form.
Joe ________________________________ From: LJ Longwing <[email protected]> To: [email protected] Sent: Tuesday, March 3, 2009 5:49:37 PM Subject: Re: External Table into a Table Field? ** You need to setup a 'vendor form' on that table, then build your remedy table field on this vendor form. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Wallace, Kelvin Sent: Tuesday, March 03, 2009 3:40 PM To: [email protected] Subject: External Table into a Table Field? ** Greetings, Listers… Solaris 10 Oracle 10g ARS 7.0.1 I have a People form (home grown ARS) that has a table field that displays all of the computer related assets assigned to an individual. I have non-computer related asset data in another Oracle table (not ARS) that I also want to display in another table field so a user can view both table fields from Remedy. I already have a db link to the other Oracle instance and I look at single records of other data in the non ARS tables. When I look at setting up the table field – either list or tree – there is no way to make a SQL call to view this data. Has anyone come across anything similar to this? If so, were you able to figure out how to make this work? Thanks in advance, Kelvin _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

