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.