hi
i am facing problem in my project ,, with report
i have Product received voucher form it contains subform for the products ,,we sometimes received more that product in the same PRV
I've created preview button to show the record as it is showing in the main form with specific design
the problem is that ,,it shows only one record in the subform even if i have more that product listed in my PRV
this is my SQL Query
SELECT tblSuppliers.*, tblproducts.*, TblTransaction. *, tblPrv.*, tblemployees.*
FROM (tblproducts INNER JOIN (tblSuppliers INNER JOIN (tblPrv INNER JOIN TblTransaction ON tblPrv.PrvID = TblTransaction. PrvID) ON tblSuppliers.Su pplierID = tblPrv.Supplier ID) ON tblproducts.pro ductID = TblTransaction. ProductID) INNER JOIN tblemployees ON tblPrv.Employee ID = tblemployees.Em ployeeID
WHERE (((PrvID)=[forms]![product received Voucher]![PrvIDtxt]));
how can i show the record as it is it showing in the form ??
thanks in advance
i am facing problem in my project ,, with report
i have Product received voucher form it contains subform for the products ,,we sometimes received more that product in the same PRV
I've created preview button to show the record as it is showing in the main form with specific design
the problem is that ,,it shows only one record in the subform even if i have more that product listed in my PRV
this is my SQL Query
SELECT tblSuppliers.*, tblproducts.*, TblTransaction. *, tblPrv.*, tblemployees.*
FROM (tblproducts INNER JOIN (tblSuppliers INNER JOIN (tblPrv INNER JOIN TblTransaction ON tblPrv.PrvID = TblTransaction. PrvID) ON tblSuppliers.Su pplierID = tblPrv.Supplier ID) ON tblproducts.pro ductID = TblTransaction. ProductID) INNER JOIN tblemployees ON tblPrv.Employee ID = tblemployees.Em ployeeID
WHERE (((PrvID)=[forms]![product received Voucher]![PrvIDtxt]));
how can i show the record as it is it showing in the form ??
thanks in advance