MessageRoger, What is the data type of that field? Certain data types are unsupported on view forms..
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Nall, Roger Sent: Tuesday, June 12, 2007 4:43 PM To: [email protected] Subject: Re: View Form Issue ** Actually that is not true. There are two columns that can be mapped to the Request ID field that are in both areas however the column that I want is no where to be found. Also, if I query the view in Query Analyzer logged in as Aradmin I can see the column that is not in the view form. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan Sent: Tuesday, June 12, 2007 4:28 PM To: [email protected] Subject: Re: View Form Issue If it is the Key Field then it will not be selectable in the list of fields. It will be mapped to the view forms Request ID field. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Tuesday, June 12, 2007 1:23 PM To: [email protected] Subject: View Form Issue ** Hello All, ARS 6.3 patch 16 WIN2K SQL2003 I am having a problem creating a View Form from a sql view. This view is a join of several tables in different databases. The JOIN criterion is the record ID for the main table. This also happens to be the only column I cannot see after loading the view into a View From object. I am wondering if anyone has experienced this issue before. Aradmin does have read and write permissions on all columns on all tables but I cannot see this one column. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.14/845 - Release Date: 6/12/2007 6:39 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
