It needs a unique field as a unique ID and Remedy's unique ID column can only be 15 bytes long.
One solution is to just add the Oracle Rownum to the query and use that as the Remedy unique Key column. SELECT min(ROWNUM) as Entry_ID, Vendor as VendorName, sum(RECORD_AMOUNT) as SUM, Journal_Entry_Date FROM TIP_MONTHLY_BILLING_DATA Group by Vendor, JOURNAL_ENTRY_DATE; Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Wednesday, April 04, 2007 1:46 PM To: [email protected] Subject: View Forms and Key Fields Another question about View Forms. Here is my SQL View: SELECT Vendor as VendorName, sum(RECORD_AMOUNT) as SUM, Journal_Entry_Date FROM TIP_MONTHLY_BILLING_DATA Group by Vendor, JOURNAL_ENTRY_DATE; When I go to create my View Form, only SUM and Journal_Entry_Date are in the dropdown list as key field selections. I went to my old handy, dandy help menu in Remedy Admin, and I found that "You must choose a character column whose name is from 6 to 15 characters or an integer field." My Vendor Field is 50 characters long. Why does it have to be 6-15 characters long? Is this something that I could request as an enhancement? Lisa _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
