XPages are here, they're big and bad and scalable. They integrate with @Formulas, which is extremely powerful. For things like repeat controls, type-ahead, etc. there are times when you use @DbLookup or @DbColumn.
But these functions are limited in returning 64K, like the days of old.
Two new ...
a pain in the ass when giving support on a Notes application or when making modifications is that without a system description or a scan using third party tools it is hard to see which dependencies their are to other Notes systems.
@dbcolumn and @dblookup commands have the reference ...
this could be usefullfor example build tagclouds via @dbcolumn / @dblookup
@dblookup should allow you to look up on multiple categorisations as you can using lotusscript view.getdocumentbykey. You should be allowed to enter in a text list so that each item is looked up in a catogorised view.