Des2k: views and keys

[Quoted] I'm having trouble using views in the data model diagrammer. I'm using views as an abstraction layer over the database. When I try to relate 2 views, it complains that no foreign key exists. If I use the tables instead of the views, it works just fine. (The views are defined to be the same as the tables)

I notice that in the navigator, views can have keys (primary/foreign) defined(????) I don't. The navigator shows my keys defined on the tables, as I would expect, with the keys attributes on the views empty.

Can someone explain the between views and keys in des2k?

Note: My database was reversed engineered into the repository.

Also, my synonyms to views did not get reversed engineered into the repository. Is des2k supposed to handle this?

• Chris Greer