Can I write select statement within a select statement

HCL Domino Domino Forum
1

Hi,

Can I write a selct statement within a select statement.What I actually want to do is, I want to select a field by the sub query and use that field to select something else from a different form.

Ex

select form=“A” where field1=(select …)

pls help

thanx

2

Subject: Can I write select statement within a select statement

No, you can only look at the document that is being acted upon by the selection formula (no lookups). If all of the data you need to examine live on the same document, the selection formula can be as complex as you’d like.