Creating views one database using forms from a different database

Can any body please help me out!!!

I would like to create a view in one database

using forms from another database on the same

server.

Is it posssible?

Thanks a lot in advance

Fraser Noronha

Subject: Creating views one database using forms from a different database

Firstly, views display Dcuments, not Forms.

And no, a view will not display documents from another database.

Subject: RE: Creating views one database using forms from a different database

Then how to go about it. Can u suggest another way to do it???

Subject: RE: Creating views one database using forms from a different database

  1. Provide a link to the view in the other database.

  2. Use an embedded view (on a form). You may display multiple embedded views on a single form, from different databases.

  3. If you need to show documents from different databases next to each other in a view, it can be done, but it is difficult, slow and error-prone. You need to maintain “shadow” documents that reflect the documents in the “foreign” database, automatically keep them up-to-date (when master documents are created, modified and deleted), and when you double click on a shadow document, you have to dynamically open up the master document (this could be done by trappint the QueryOpenDocument view event. But unless you are really competent, have lots of time to spend, and are willing to accept that it may not be possible at all, due to some arbitrary Notes client behaviour (what other people call a bug), I would find an alternate way of solving your problem.

Subject: RE: Creating views one database using forms from a different database

Depends what this app is. Why not simply move data in from your other database?