Selecting documents created from a form in a different database

Hi there!

I have basically got a database of contacts being used for a specific purpose. What i have started doing is setting up a more generic all-purpose database, from which I would like to be able to view the contacts stored in the other database, as well as contacts stored in this database.

Selecting documents created using my NewContact form in the new database is easy: Select form=‘NewContact’ but how do I select documents to display in the view that are stored in the other database and created using the BasicContact form from that database?

Thanks for your help!

Duncan

Subject: Selecting documents created from a form in a different database

One very quick and effective solution would be to create a new form, set it’s saveoptions to 0,(so you are not prompted to save changes to it every time a document is created), create a view in the other database that only displays documents created with the form that you have specified, and embed that view into your new form. Or use an existing view in that database, and create a show single category formula when you embed that view that filters down to only show documents created from the form specified.

Subject: Selecting documents created from a form in a different database

If I’m understanding your request correctly, you want to have a single view that combines the documents from two different databases in a single listing? I’m not sure how that could be done, as I’ve never needed to do that. I wonder if NotesSQL or something like that could work?It may be possible to use multi-database searches… I know you can have multiple name and address books with a cascading affect, but I’m not sure how that would be applied to this case.