<div>
try @Unique(@DbLookup(........<wbr />.)) &nbsp;
</div>


<div>
<div class="content wysiwyg-content">
<br />
Hello,<br />
<br />
I've got a Dialog List field which uses a View Dialog for choices options. &nbsp;The View is displayed and the value in column 1 of the selected document is returned to field 1. &nbsp;How can I add to this so that the values from column 2 and column 3 are added to fields 2 and 3? &nbsp;<br />
<br />
The issue is in the View Dialog there could be several options with the same name (for example there are 10 John Smith) and when I compute fields 2 and 3 using a standard @DbLookup it pulls in the value from all 10 John Smiths into fields 2 and 3<br />
<br />
I'm convinced this should be easy but today is not my day. &nbsp;Too many easter eggs.<br />

</div>
</div>



Hello,

I've got a Dialog List field which uses a View Dialog for choices options.  The View is displayed and the value in column 1 of the selected document is returned to field 1.  How can I add to this so that the values from column 2 and column 3 are added to fields 2 and 3?  

The issue is in the View Dialog there could be several options with the same name (for example there are 10 John Smith) and when I compute fields 2 and 3 using a standard @DbLookup it pulls in the value from all 10 John Smiths into fields 2 and 3

I'm convinced this should be easy but today is not my day.  Too many easter eggs.


Use View Dialogue for choices options

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.