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.
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.