I need a way to filter a document library based on the value of a lookup fields additional column.
Set up: Lookup list has various fields including Company and Accountant. Document library has field that looks up the Company name from Lookup list AND is set to show the additional field Accountant.
Problem: Document library correctly displays the associated Accountant for the selected Company (shown as Company:Accountant) but I can't filter the library by that result. I was thinking I could create a workflow which would allow me to copy the Company:Accountant into a single text field, but it doesn't show up as an option when creating a workflow.
The users who create the entries in the Lookup list are not the same ones uploading content into the Document Library, therefore the need to bring over this data is key to the management of the contents in the Library.
Any direction or assistance in getting this to work would be greatly appreciated.