Create a view concatenating information to use in @DbLookup
Posted on 2008-02-01
I have Documents describing Reports that have the fields, RptName, RptRecipient and AltRecipient.
Any one recipient might be on many documents, there are about 80.
I want a view that will show a person in one column, whether they appear in the RptRecipient OR the AltRecipient field in any of the documents, and the associated RptNames they show up on.
So the result might have, in one row
Jane Doe Expense Rpt, HR Rpt, Vacat Rpt
Where there are three documents, one for each report, and Jane may have been in either the RptRecipient OR the AltRecipient field, but in this view there is only one row.
The purpose is to use this view for an @DbLookup formula based on the user name.
1. I have a view that displays the RptRecipient and one Report per row, so there are multiple rows with one user name, and I don't know if @DbLookup will step through all the rows
2. I can't get the first column to list both the RptRecipient and AltRecipient together. I've tried RptRecipient : AltRecipient but it won't show the AlRecipient.