DBlookup to look up list of names for multiple forms

HCL Domino Domino Forum
1

I am trying to lookup a list of Values from a list of numbers that are gatherd in a field

lookup Nlink contains

3,lara

11,hank

17,thomas

18,jeff

20,mike

21,tony

22,brad

65,christy

Field_0 = “20; 3; 21; 17; 18; 9; 11; 22; 3; 65; 20”

Field_1 = @Sort(Field_0) = “11; 17; 18; 20; 20; 21; 22; 3; 3; 65; 9”

field_2 = @Text(@DbLookup( “” : “NoCache” ; “” :“” ; “NLinks”;@Text(Field_0) ; 2))

field 2’s output is

"hank; thomas; jeff; mike; mike; mike; mike; mike; mike; mike;

but should be

“hank; thomas; jeff; mike; mike; tony; brad; lara; lara; christy”

what am i doing wrong ?

how do i fix it?

thanks

2

Subject: DBlookup to look up list of names for multiple forms

If you want us to correct your formula, you need to show the actual formula, not an approximation of it. One character more or less can make a lot of difference. I see you here doing assignments with = rather than :=, and you use the name Field as your lookup key, which is not the name of either of the temporary variables you created.

I don’t understand what the purpose is of sorting numeric values alphabetically.