I have a situation where i have to do a search on multiple lists at once.
List A - Field A, Field B
List A - Field A, Field C
List A - Field A, Field D
When a user searches by Field A i want to pull all records from all lists. How do i present it after u have done the search. What web parts should i use?
Is is possible to search on multiple lists. How to do it through designer?
Do i need to a roll up view and search on it. If its possible..
Should i do join of lists and try to filter it based on FIELD A? Can we filter on joined lists?
Any ideas on this ....
Thanks a lot in advance.