Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What should I do? I really need to make this work...
I have tables,
RR_Header
rr_number
date
RR_Details
rr_number
item_code
received_qty
DR_Header
dr_number
date
DR_Details
dr_number
item_code,
delivered_qty
THIS IS ONLY SIMPLE TABLES....
RR_Header should link to RR_Details (rr_number)
DR_Header should link to DR_Details (dr_number)
RR_Details should link to RR_Details (item_code)
RR_Header should link to DR_Header (date)
So date I could have this report...
DATE | ITEM | DELIVERED | RECEIVED |
---|---|---|---|
12-12-12 | A | 10 | 15 |
11-11-11 | B | 5 | 8 |
but damn, i hate this thing... TABLE STRUCTURE LOOP... Whatever! It made my blood gets hot... Please help me about this...
I really need to meet the deadline...
I've attached the screenshot of the table structure...
Hi Mig,
I will apply the latest one okay? Will inform once work!
Regards,
Bill
Hi Mig,
Have you check on this?
What if the dr_number of DR_Details should be link to SR_Details ref_no
Consider the following tables and data is related to above...
Example:
DR Detail
Item dr_number
A DR001
A DR002
B DR001
SR_Details
sr_number Item ref_no Returned Qty
SR01 A DR001 15
SR02 B DR001 8
SR_Header
sr_number date return
SR01 12-15-12
SR02 11-20-12
I need to have this report
1) DATE ITEM RETURN DATE DELIVERED RETURN
2) DATE ITEM SELL OUT SELL IN
*Sell out = Delivered - Return
*Sell In = Received
-I did what you have did w/ second qvw, I've notice the item has been link between DR Details and SR Details, could you make it DR Details (dr_number) and SR_Header (ref_no) ?
-Im sorry I forgot to tell you that the ref_no is not in SR_Details... it is in SR_Header...
The link of SR_Header to DR_Details is below
SR_Header
ref_no as dr_number
SR_Details
dr_number
something like that... Hehe
Hi Mig,
Thanks for the help. I come up this structure. Thanks for the ideas. Got knowledge. Hehe
Best Regards,
Bill