I have a question if @DBLOOKUP could be used to look up values.
I have 2 views in 2 diff. DB’s
1st View has Name and a Code
2nd View in the other DB has Name and Date along with other fields
I would essentially like to merge the two views or do a Lookup such that the data from the 2nd view is mapped to each name in the View 1 and made available in the first view in additional columns.
Any hints would be appreciated.
Subject: DBLOOKUP in a View Question
As Carl said, if you want it in one view, it must be in the doc in that view; no view to view lookups allowed.
Having said that, if the two db/two view design makes sense (ie the data are related but different or different groups own each set of data) just leave it split up; why change what’s working? If the two dbs/views should be one, different story. Just write a bit of code in your ‘combined’ db to snag data from the other db and pull it into the existing docs in the ‘combined’ db.
Doug
Subject: DBLOOKUP in a View Question
You want to do what is a called a relational join. Domino does not do relation joins. If you want the data to show in the view, it needs to be in the document.