database confusion 1

[cramd]

My database has two forms and two views, each form corresponds to a view; (1)frmMessage contains two fields "subject" and "body" and uses vwMessage, (2) frmSelectedEmail contains four fields, "name", "email address", "city", "state" uses vwSelectedEmail.
When I delete record 1 from vwMessage it also deletes record 1 from vwSelectedEmail - I only want the record from vwMessage to delete. Since the information in the vwMessage is not related to the information in vwSelected Email, should I be creating two completely different databases, one database that holds the various email messages, and the other database that holds the users that are to receive the messages. Is my problem that I am combining two completely different types of information into one database?
cramd

 

[pmonett]

What are the Selection Formulas in both views ?
It sounds to me that you are actually listing all documents in both views.
If each document type is created with a specific form, and if each view only lists documents of its own form, then what you describe cannot happen. Therefor, the only possibility I see is that there is no selection formula limiting the type of document being shown.

So I suggest you review the selection formula in your view design. There is certainly something to correct there.

Pascal.

 

[cramd]

Pascal,
You are right, that is exactly what is happening.
I'm thankful that you could read my question and understand what I was asking!! "ViewSelection" - makes all the difference. Now, compare this to an Access database, one database many tables, can I compare the same theory with a Lotus database, one database with many "views"??
You earned another star!
cramd

 

[pmonett]

Indeed, each view in Notes can be compared to a table in Access.
However, I beg of you - do not extend any comparison to Access any further !!
Access is (or tries to be) a relational database management system. Notes is not relational, at all, at any time. Notes is a document database management system, and anyone telling you otherwise is wrong.
You can simulate relational keys in Notes, but you have to code those relationships yourself and it is up to you to ensure - with more coding - that the pseudo-relational code in your db reacts correctly in all situations. I have done this, and it is far from impossible, but it is also far from being as automatic as a true RDMS would be.

In any case, I'm always glad to be of help.

Pascal.