I am fairly new to Domino. I have search through the fourmns and have not seen an solution for what I am trying. In Access, I have run a list of to different tables and generated a list of not matching entired. In this case, I have a Form to list Names and another with list of classes. I have built the views for each of these. I have another form where you match up a name with a class along with some additional information. I am able to build a view off of this that shows who attended what class, but am having trouble generating a list of those who did not attent the class since there is not a document to reference. Any assistance would be greatly appreciated.
Subject: List Unmatched Items
You mentioned three forms; I’ll call them Student, Class, and Registration. This database actually sounds quite similar to one I did as a sample of fancy views, which you can download free from The View’s website. I actually have the same three forms. I didn’t have any view exactly like what you’re talking about, but the application does demonstrate various techniques for getting information to appear either in a view or a folder.
Notes is not a relational database, and you can’t build views that select documents based on information not available in that one document. Nor can you display information in a view column, containing information from a document other than the one on that row. However, you can arrange for documents to have information added to them behind the scenes so that they do contain whatever you need to make your view. This may result in some duplication of information, which may not delight relational database engineers, but it is a way to do it.
Another thing you can do, is create true relational-based views by exporting document data in real time to a DB2 database via NSFDB2. Read about it, see what you can do.
Subject: RE: List Unmatched Items
Many thanks for your assistance. I started looking through the example that you sent me. It did spawn a few ideas… I will post what I finally get to work when done.
Subject: List Unmatched Items
Thank you all for your help.
Since this report was only needed at the end of each month. I am exporting the data and using Access to compile the list.
Seems like this will work well.
Thanks again
Subject: List Unmatched Items
Lenny,
You would have to write an agent to figure this out for you. It would not be possible using views.