advanced data view - please advise

[Janusz Falkiewicz]

Hi,

I want to create advanced data view, which displays data from five
lists:

1. Orders
ID
Pos Material - lookup as Material Name
Quantity
Market - lookup as Market Name

2. Pos Materials
ID
Category
Material Name

3. Prices
ID
Min
Max
Price
Pos Material - lookup as ID

4. Market Orders
ID
Market - lookup as Market Name

5.
Markets
ID
Market Name

Advanced view is on a Market Order form.
This should be a grid of:
All Pos Material - group by Category
For each Pos Material:
list of Orders with the same Pos Material and Market(Market Order)
For each Order:
list of Prices with the same Pos Material and where Min(Price) <=
Quantity(Order) <= Max(Price)

Please advise, how to create such data view, using SPD and merged
(multiple?) data source...


Regards
Janusz

Ps.
Now, my problem is to create correct filter. I do not know how to
compare data with "parent of parent" rows (with "single parent" is
OK.).