Because that is the length of the request_id field on all Remedy forms and request_id is the primary key.
On 4/4/07, Kemes, Lisa <[EMAIL PROTECTED]> wrote:
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"
-- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
