Ok,I have a situation where I need to display a view that contains field value from two forms which is connected via a "CVNo" field. At first I thought it was simple and dived in. I added the form names in the view selection formula of the notes view and then created columns and assigned their respective values, but what happened was the output I got from doing so is a very jumbled and cluttered view. Based on my understanding the notes view displayed the column values from each form differently. I don't know how to do this or if this possible in notes view. All help and suggestions and are very appreciated.
In Lotus Notes view you cannot display documents connected to each other by a custom field. The only connection which can be displayed in Lotus Notes view is parent->response document hierarchy.
And please note that you do not create view that displays values from forms. You create view to display field values from documents, which are filtered to be shown in this view.
If you have documents, with field Form, one Form1 and another Form2, then create a view with selection formula:
SELECT Form = "Form1" | Form = "Form2"
Every row in the view represents a document (either with Form1 or Form2 value in the Form field).
And every column may contain a field name or @-formula to evaluate with every shown document to display a value in this column.