Dear Barbara,
sCode = Supplier's product code
sDetail = supplier's product description
pCost = Product's Cost
pDiscount = Product's discounted price
sID = supplier's ID
oMID = our Product code
I would like to select from the purchasing history to form a list of product code available with the same product and same supplier, i.e.
SELECT DISTINCT sCode,sDetail,sID,oMID FROM stockPurchase WHERE sID= ?lsID AND oMID = ?loMID ORDER BY sCODE
However, it is more informative if I can add pCost & pDiscount for reference...
SELECT DISTINCT sCode,sDetail,pCost,pDiscount,sID,oMID FROM stockPurchase WHERE sID= ?lsID AND oMID = ?loMID ORDER BY sCODE
However, in that, even there is price difference, there will be additional record for that... so I don't want it...
Best regards,
Aaron Chu
********************************************************
Working with Visual FoxPro is a lot of FUN!
********************************************************