Lotus Notes View Selection Criteria

I have a database with two forms I want to link together in a view. One form contains various fields including employee name. The other form contains a date and employee name. How can I set up a view to link on employee name by date. Any help would be greatly appreciated and I have only ever set up a view on one form.

Subject: Lotus Notes View Selection Criteria

Hi Julia from question you wrote, you can get name and date only from form b. You cannot display two different forms in one view row. You sort both forms in view by employee name and if you are able to use formula you can display informations based on what for m was used to create document

Subject: RE: Lotus Notes View Selection Criteria

Hi Michael

In my database, Form A contains a Date and an Employee Name. I want to link this Name to a Name field on Form B and display various information from Form B only on the view.

Is this possible at all in Lotus Notes. Many thanks for your help.

Julia.

Subject: RE: Lotus Notes View Selection Criteria

Hi Julia

Notes isn’t relational in that sense, i.e. you can’t link two documents together via a key field and treat the result as a single entity for displaying in a view. One option is to add the field on form A to form B and use an agent to update existing documents.

Will

Subject: RE: Lotus Notes View Selection Criteria

Thanks for your reply Will, its back to the drawing board.