Well Tricky, There is a section in the manual, which manual depends on your version, that tells you what field types are supported in Remedy View forms, if you don't have any of those, then they won't show up as available fields, pay special attention to the requirements for the Request ID field.
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of tricky maybe Sent: Friday, May 23, 2008 8:02 AM To: arslist@ARSLIST.ORG Subject: No available columns when creating a view form from SQL ** I have a view on SQL that I want to load on Remedy so I open the admin tool and click on new object then I select view form and type in my database table ARSystem.dbo.MyViewForm and when I click on load I don't get an error but there's no available columns showing up. MyViewForm is a view I created from a linked server using SQL. I can query that view on SQL using management studio with no problem. Do you know why I can't load it on Remedy or can someone show me how how to do this? Thanks __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"