Hi Paul
You are correct, the table which contains the Product details has two fields (ProductCode, ProductName).
On the Form I have added the tblProduct.ProductCode field and the other fields from the tblDataEntry, then I have created a text box with the information you have supplied.
When I...