Lisa, It's prompting for a Request ID field that has to be a character field of length 6-15 characters.. hope this helps..
Joe -----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 ____________________________________________________________________________________ 8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime shortcut. http://tools.search.yahoo.com/shortcuts/#news _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
