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.