I have two SharePoint lists: Staff List and Provider Directory. The Staff List has a lookup column to the Provider Directory.
Staff List:
Name
Provider (linked to Name in Provider Directory)
License
Degree
Specialties
Provider Directory:
Name
Ages
Location
Insurance
Additional columns, but not needed in the combined collection
I would like to create a collection that includes all of the columns from the Staff List and a couple of columns from the Provider Directory list (by lookup of the Provider in the staff list), and then use this as a data source in a search screen. The user could then search by location, by insurance, by license, by degree, by specialties, etc., and find all the staff (attached to a provider), that meet the selection.
I was thinking a collection could do this, however if there are other ways to accomplish this, any help in pointing me in a direction would be most appreciated.
