Include field in view from related doc?

HCL Domino Domino Forum
1

As far as I can see, with Notes, this is not possible but I thought I’d ask anyway just incase there was a trick which could be used!

I have a view based on a “Job” form. One of the fields in this form is a “Computed For Display” field of “ClientName”, which uses @GetDocField to retrieve the name of the client from a client document. This is so any changes to the client document are reflected in the job details without doing an edit/save.

I want the job form view to display the clients name but it does not appear this can be done without saving the clients name to the job document? Is there another way?

2

Subject: include field in view from related doc?

Not in the Notes client in current (or older) releases. It is possible on the web (methods have already been posted here), and I have it on good authority that it will be possible with the DB2 back-end option in Notes 7+. A view is not a query – it’s more akin to a subset of a single data table in other databases. While values in a view can be computed, they can only be computed from the “current” document – no peeking at your neighbor’s data.