One way of classifying the resources provided on my site is by whether they are a file (e.g., a PDF, Word Doc, Excel file) or a link. Links can be to an internal resource, i.e., another HTML page, or an external resource, i.e., content on a different website. Beside the distinction between file and source, all other categories of metadata are the same.
In SharePoint 2010 Foundation, I have a library for all the file resources, and a list for all the link resources.
I want to provide two things: 1) an easy way for content owners to add resources, and thus the single library and single list system, and 2) a "merged" view of those two resource sources from which I can generate displays of those resources filtered and grouped in myriad ways.
I figure the first goal is covered because my content owners only need to work with two nearly identical interfaces to add assets. I'm wondering about the second part...
Is it a reasonable solution to create a DataView that pulls its data from these two sources? Is this the best - or only - way to do what I'm shooting for?