Purchase Table includes the following fields.
PurchaseID
PurchaseDate
Remark
Purchase Deatails Table includes the following fields.
PurchaseDetailsID
PurchaseID
ProductID
BatchNo
Quantity
Price
Amount
here sample data
PurchaseID PurchaseDate
100 12/1/2009
101 ...