I'm trying to perform a reporting of online sales via sub-summary but to no avail.
I have 3 tables:
Transaction table - main table to store order details
Ticket table - a transaction may consist of 0 or more tickets.
Concessions table - a transaction may consist of 0 or more concession items
I can't seem to perform a sub-summary to display the above information correctly.
Below is my setup:
Order_Reference | Total_Order_Value | Transaction_TimeStamp (sub-summary sorted by __PK_OrderID)
T_Description | T_Seat_Location | T_Price (sub-summary sorted by __PK_TicketID)
C_Description | C_Price | C_Quantity (sub-summary sorted by __PK_ConcessionID)
Note: a transaction will have one of the following attributes:
Tickets only, no concessions
Tickets with concessions
Concessions only, no tickets
Thanks in advance.