When I use a Quick Fields "Lookup", if the query returns no rows then the Quick Fields session fails and the document is stuck in the session.  I do know how to circumvent that in the case of a lookup that returns just one column of data, using constructs such as "select nvl(max(..." and so forth.  However, the only way I know to return multiple columns and avoid the "no rows" problem is to create a separate lookup for each column.

So, my question is, am I missing something?  Is there a better way?

I use Rio 8.3.