I am creating a couple of View forms to a SQL DB table from an Oracle DB remedy system using a dblink. Via the DB Link I am able to connect to the table and load all the fields but I do not see a column in the key field drop down of the create view dialog.
In both tables the field I am wanting to use as the key is a 15 byte varchar, Null not allowed, and it is not designated as a key in the SQL db. On the first table the only column I see is a 4 byte int status field, and on the second I do not see a column listed at all that table which only contains varchars. any ideas Thanks G. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
