Malcolm, If I understand you correctly, you have a field called Client in your HPD:HelpDesk table. You want to know the origin of the data that exists in this field?
If that is so, enable your Search Database. You can do so in the Admin Tool using Tools -> Enable Sync Search Database. (If this option is grayed out it would mean someone has already enabled it.) This operation creates 3 tables with the prefix object_search_. Then run the Tools -> Sync Search Database. This is a time consuming and database intensive process that may virtually lock your database - well not lock but if you run it during production hours you might get a good yelling from your users who are very likely to experience timeouts / bad response from the AR Server on most of their operations. Either do this on a development server when there is no major development work done or run it during non production hours. DO NOT CLOSE YOUR ADMIN tool till the Sync Search database process completes. On enabling this database and running the sync, you will get a Related Workflow tab enabled on your Admin tool when you double click on the Client field. This will tell you all the AL's and Filters and Menus tied to this field and may lead you to what you want. Hope this helps... Cheers Joe D'Souza-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Malcolm McCaffery Sent: Friday, October 12, 2007 9:56 PM To: arslist@ARSLIST.ORG Subject: list all clients in HPD:HelpDesk form using AR ODBC driver ** Hi There I'm currently writing an automatic reporting tool in VB.NET using the AR ODBC driver. I'm not an expert on Remedy but it appears that the ODBC driver automatically joins tables. However in the HPD:HelpDesk table is a 'Client' field. How can I find out what table this comes out of ? I want to retrieve a list of all Clients to populate a list box. Kind Regards, Malcolm McCaffery http://www.tiange.com.au No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.14.10/1070 - Release Date: 10/14/2007 9:22 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
