jkee54
asked on
Create a view concatenating information to use in @DbLookup
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
Recipient Report
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.
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
Recipient Report
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That did the trick, works like a charm, thanks!
https://www.experts-exchange.com/questions/20736189/Multivalue-Field-In-View.html
also this might be helpful.
Also , can either field be blank or have multiple values
Also have you considered using @DBcolumn instead of @DbLookup ?
I hope this helps !