>I have an app with 2 databases. I'm trying to add a view to the second one (a local repository) but every time I set up the view, it attaches to the first dbc. I've tried selecting the 2nd dbc and then adding; selecting another view in that dbc and then adding; etc. Obviously I added the first couple of tables/views without problem. So what am I doing wrong now?
How are you adding the view? Is your view based on tables from another dbc?
If you are using code (CREATE SQL VIEW) just make sure that the correct database is current (SET DATABASE TO MyDBC), and issue your command.
If you are using the database designer, just rightclick and choose "Create View".
> Also, is there any way to "move" a view from one dbc to another?
Not directly. But there are several 3rd party utilities that can help you with this; you can download my eView from the files section here, and use it to generate view code that can be run on a different database to duplicate the view definition.
Erik Moore
Clientelligence