Hi!
I want to do a lookup on tblProduct before entering the price of the product in tblPurchaseProduct.
tblPurchaseProduct (PurhaseProduct_ID, Purchase_ID, Product_ID, Price, Quantity, Cancel)
tblProduct (Product_ID, Name, Price)
The names in my form are the same - Product_ID and Price.
I...