Ok, here goes. Ill do my best to explain.
I am trying to return a list based on a field called user_name.
I have this formula but it only returns the first value.
jobname:=@DbLookup(“”;“”;“AllJobs”;User_Name;2;[FailSilent]);
I want it to return all the values in column two but only the ones that have the user_name in the document. Make sense?
Subject: Create Dynamic List
Not sure if I understand…
How do you know that you’re only getting one value back?
If the docs in the view contain a field that matches the value for your key ‘User_Name’, and that field is the first sorted column in the lookup view (“AllJobs”), then it looks right to me.
If you’re checking the value(s) returned using @Prompt, be sure you use [okcancellist] and display the jobname values as the list parameter.
Doug