I have a sharepoint FBA application, where I have multiple list for multiple forms.
Now each form will have a status like approved, rejected, draft which will be based on a drop-down column in each list.
Now I want to show the forms
i.e items from each list into a single list on the basis of their status which is submitted, draft and rejected.
How should I approach to this ?