10-29-2009 12:43 AM
I have done this in the web client successfully in 7.2. Before a better solution was around, I created a dummy table in the db manager with the desired fields, then dropped the table in SQL and replaced it with a view with the exact same structure, and it worked fine. The table I created had accountid as the primary key, but it was not associated with the account table as far as db manager was concerned, so SalesLogix never tried to insert or delete any rows from the table (it was not an extension table). I manually created a relationship between the tables (one being replaced with a view) and it worked.
David Nelson
ISM
Seattle, Washington, USA