@DBLOOKP in a view SELECT statement?

HCL Domino Domino Forum
1

I have two forms:-FormA: Users (@V3UserName) associated with products

-FormB: Details for products

And two views:

-ViewA: “SELECT FORM=FormA”, Col1=user, Col2=product

-ViewB: Details for all products associated with the user

For the SELECT statement in ViewB, I expected to use @DBLOOKUP against ViewA to identify the products associated with the current user, but I find @DBLOOKUP does not work in SELECT statements.

Any suggestions?

2

Subject: @DBLOOKP in a view SELECT statement?

You cannot insert any variable ‘parameters’ in a view selection formula.

I think the best solution for your problem is to use an embedded single category view.

For more complex tasks, a solution can be to calculate the document collections in LotusScript and put them all in a folder. You can easily find more details by searching this frum