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"
