Without the REQUIREMENTS of the external db not having any column (field) that enforces non-null and unique values, you CAN NOT create the view form.
You need to talk to your dba's. Kevin. --- On Fri, 5/23/08, Kevin Pulsen <[EMAIL PROTECTED]> wrote: From: Kevin Pulsen <[EMAIL PROTECTED]> Subject: Re: No available columns when creating a view form from SQL To: [email protected] Date: Friday, May 23, 2008, 3:29 PM Just want to make sure of a couple of items. 1. You have created a Linked Server (From the AR database server) to your external database. (Are both of these db's SQL 2005?) 2. ARAdmin has rights to access the external database. Kevin P. ** When I hit load nothing shows up on the available columns list. The reason for that according to the manual is because the database view must contain an integer or character field that enforces no null value and unique to act as the request ID field and I don't have a column(field) that meets that requirement on my database view. I do have a field that is unique that I can use how do I change the type of that field to enforce the no null value? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
