Stump the Panel: SharePoint Q&A

I have a need to create a screen that will have two parts, a top part which would be a filter grouping or a list of fields that the user can input or select and a bbottom section that will show the results of the filters.

For a simple example using the following fields:
Deal ID
Segment
Value
Deal Name
Deal Date
Deal Status

Top part of screen

Deal ID
Segment

Bottom Part of Screen
Deal ID Deal Name Deal Status Value Segment

Why not create a DVWP that displays all of that information? That way, the user will not have to remember Deal ID's in order to see the information they need.

It almost seems like there's more to this solution than what you have already led on...

Perhaps there is more to it, let me try to be as thorough as possible in the explanation.

Ulitmatley what will happen is that there will be many lists that connect to each other via a common element called DEALID.

In the list called DEAL we will have a list of DEALS and high level information about each of them.

The aditional lists so far are:

SOLUTION - Information about a the solution for the DEAL
FINANCIALS - Financial information about the deal

there could be as many as 20 of these by the time this project is done.

So looking for a way to design the initial screen that is user friendly and condusive to growth.

My thought was to divise a way to have a filter section, a content sectoin and somehow have tabs that would point to the sublists that would be accessed via solution.aspx?DEALID={@DEALID} example