Hi everyone. Please I'd like to know if anybody has encountered this problem before. Here's the scenario. I've got a datagrid view Bthat is a child table from another table A. one of the fields is the productID which I have bounded to the Product Table to display the name of the product rather than the ID. What I want to achieve right now is if a new record is created I want on click for the price column to populate after the product has been selected. Below is a similar case using NorthWind database in Access. Any help will be greatly appreciated.