I have been all over the place and am running myself in circles.
Let's say I have two custom libraries that contain documents. In the library I have a custom field where we state what type of document it is, ie Contract, Pleading & Discovery (this is the same in both libraries). When a doc is saved we state what type of doc it is.
I want a custom list that allows the user to select "Pleading" and it show all the docs that match that type from both libraries. I know how to create the views, what I do not know is how to pull the data. When I use the built-in "custom list" and create a column item "Lookup", I can see my libraries, but I do not see the custom columns I created within that library.
Is this possible? Am I missing something so bloody obvious?
Any help is much appreciated.