Hi Kali, The ODBC driver provided by Remedy is not intended to provide database level access to the system. It is a read only ODBC driver for reporting purposes only. This is unlikely to change in any future version of Remedy as there are already many more appropriate ways to write to the Remedy database eg. API programs, web services, email etc.
Having said all that it has always been possible to join two tables by using two different data sources both pointing to the same server. Because this join is emulated via multiple queries rather than by creating a join on the database server it is not efficient at all and it is best to do your joining via Remedy join forms. One neat new feature on 7.5 is that it is now possible to join view forms and remedy forms together. Rod 2009/11/19 Kali Obsum <kali.ob...@macquarie.com>: > ** > Hi everyone, > > From what I know, the ODBC in Remedy 6.3 doesn't support joining tables. > Does anyone know if this is still true in Remedy 7.5 ODBC, or is it already > able to support joins? > > Regards, > Kali > > > NOTICE > > The information contained in this email is confidential. If you are not the > intended recipient, you must not disclose or use the information in this > email in any way. If you received it in error, please tell us immediately by > return email and delete the document. We do not guarantee the integrity of > any e-mails or attached files and are not responsible for any changes made > to them by any other person. > > > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"