Order & receipt report

[mithani]

hi all,

I have four tables:

PurchaseParent
PurchaseOrderNo
PurhcaseDate
Payment

PurchaseChild
PurchaseOrderNo
ItemCode
Unit
UnitPrice
Length
Finish
Qty
Remarks

ReceiptParent
PurchaseOrderNo
ReceiptNo
Date
dueDate

ReceiptChild
ReceiptNo
ItemCode
IQty
IUnit
IRemarks

With the help of you guys, my purchase & receipt forms working great. What I am doing now, I have made one query; included all above four tables. I have designed one report "Purchase & Receipt report". At the top of the report(header) I will show the purhcase order detail and then I have one Subreport(at main report header) which includes all items of purchaseChild table. In main Report detail I am mentioning detail of items received from PurchaseChild.

What happening, for example, I have made purchase of two items AAAAA (qty=100) & BBBBB(qty = 50). I have only received AAAAA partially three times(25, 35, 40).

When I print my report, subReport where I want to show both purchase items(AAAAA & BBBBB) as a actual purchase, shows only AAAAA three times. My received item detail shows actuall receipt. Only the problem is in SubReport area.

My table relation detail:
PurchaseParent.PurchaseOrderNo = ReceiptParent.PurhcaseOrderNo
ReceiptParent.ReceiptNo = ReceiptChild.ReceiptNo.
ReceiptChild.ItemCode = PurchaseOrderChild.itemCode

thanks for your help

mithani

 

[mithani]

hi,

Here I am attaching my db. Please see where I am doing mistake.

thanks

mithani

 

[mithani]

Not to worry, my report working. Problem was in relation area.

mithani