First of all, let me show the ERD:

         Qcust 0----------------- Customer
           +                         +
           /\                        /\
        Quotation     Item         Orders
           +      -----+---------     +
           |     /               \    |
           /\   /\               /\   /\
          Quochose               Chooseit

Qcust: Quotation Customer
Customer: Real Customer
Quotation: Quotation Header/Footer Info.
QuoChose: QUOtation Choosing item, QuoPrice info...
Orders: Real Orders
Chooseit: Orderline info including item, qty, TruePrice info...

---

Currently, My boss request me to make a Customer/Qcust report on
What have been Quoted item, Ordered Item, Qty and each Price(s).

So, Should I Union two tree to make a View/report?!
Q.. Table and non-Q.. Table?!
but some of the fields and keyname are different.

---

Boss expected report will be:

Cust_no: _____ Cust_Name: ______ Page: ___

Detail Information:
ItemKey   QuoDate    QuoPrice    OrderDate    Qty    TruePrice ~~~
......    .....      .......      .......     ..     ........
                                  .......     ..     ........
                                  .......     ..     ........
......    .....      .......      .......     ..     ........
                                  .......     ..     ........
......    .....      .......   (Empty means Quoted but no orders)
......    .....      .......      .......     ..     ........
                                  .......     ..     ........
                                  .......     ..     ........

---

Since the expect the item information can put at same Line....
that means, it will be Detail on detail show....

Is it possible to make it?!

2 Big problem are:
i) How to make a View to carry Right info, So that I can show it
on Grid. I suppose to use (Cust_no=?EnqinfoCust_no) in Where cause
ii)If user think the info. is needed, how to put them on report
designer. ( I mean the detail on detail puting...)

Thanks for help.