@Dblookup

Hi,

I am using a @Dblookup in a button. I am getting some number based on a Key Value which is a Name. The problem is i have that name twice in the View, thats the reason i am getting Handle of 2 docs. I want to have only the first doc handle. How can i do this. Please suggest me. This is the code i have written.

C:=@DbLookup(“Notes”; “”:“”; “Lookup”; Name; “ID”);

I am getting C:=1;2

I want only 1 in C.

Thanks in Advance

Subject: @Dblookup

Try this…

C:= @Subset(@DbLookup(“Notes”; “”:“”; “Lookup”; Name; “ID”);1) ;