Howard, What you are looking for is a 'View' form. The remedy user (Default 'ARAdmin') will need to have access to the view/table in question to be able to access the data, and the data must be of specific data types (check out the integration guide for specifics).
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Richter, Howard (CEI - Atlanta) Sent: Monday, September 17, 2012 9:27 AM To: [email protected] Subject: Question how to create a Remedy form to view a MSSQL view or table ** All, As I get older I forget things, so I need to ask. I need to create a Remedy form, so I could search an MSSQL view or table (not sure if I will have access to the table or if the DB will need to create a view). This new Remedy form will not be updating the view or table, just searching it. As always thanks for any ideas, Howard Description: Description: Description: Cox Enterprises, Inc <http://www.coxenterprises.com/> Howard Richter, Remedy Administrator 6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524 Email = [email protected] <mailto:[email protected]> Office = 678.645.4633, Cell = 404.226.2745 Cox Innovation Agent (CIA) Description: Description: http://innovation.coxenterprises.com/ideas/Badge%20Library/BadgeA-Md.pngDescription: Description: http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge20-Md.png <http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge20-Lg.png> Description: Description: http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge50-Md.png <http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge50-Lg.png> Submit your idea today for a chance to earn a badge and be entered into a monthly drawing for a $10 gift card. Submit your idea: http://innovation.coxenterprises.com/ideas <http://innovation.coxenterprises.com/ideas> View your badges: http://innovation.coxenterprises.com/ideas/SitePages/yourbadges.aspx <http://innovation.coxenterprises.com/ideas/SitePages/yourbadges.aspx> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
