@Dblookup for dialog lists with multiple criteria

HCL Domino Domino Forum
1

I am a noob developer and I’ve run right into my first hurdle.

I’m creating a DB which keeps track of companies as a form which is used as a lookup list for attributing employees to companies where they are employed.

Now, there are many different types of employees and they all need to be sortable so I can make a list of all people who are type x employee of company y.

My thought is to make an @Dblookup look for employee names only where their company is the one listed in the company lookup dialogue list, and where their employee type is listed.

I’ve run through the documentation and these forums and have figured out how to look up one or the other, but how do you append a secondary lookup criteria? Can you just do a 2nd @Dblookup, or is there (preferably) a way to specify multiple filtering criteria in one @Dblookup?

Thanks in advance,

Sam

2

Subject: Search the forum and you will find many solutions

3

Subject: @Dblookup for dialog lists with multiple criteria

Create a hidden view that shows the first column being a concatentation of the company + employee type, the second column being the employee name (assuming I have this right?)

Then do one @dblookup and pass the concatentioned value as well to the function and return the second column.

I often end up with extra hidden views in order to do this kind of thing, but it works. Just comment the view so that you don’t delete it later by accident, when you have forgotten what it’s for!