Hi All,
I need some help solving an issue I have. We have one database that contains documents with two fields on it that we combine to form a key to lookup documents from another database. This is done by concatenating the two fields and then doing a lookup in a view in the other database and showing the relevant docs in an embedded view. It works great but the problem is now I found out there can be multiple values in the two fields, so the Show Single Category option does not work because it needs to be a string.
Any ideas how I can use two multiple value fields to lookup the associated documents in another database and display them on the document? Hope this makes sense…
Thanks,
Dustin