Member Avatar for angelmichael4

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.

dbImage.jpg 291.34 KB
  • 2 Contributors
  • 2 Replies
  • 69 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by angelmichael4
Member Avatar for lolafuertes

Use the SelectedItemChanged on the combo to cath the new selection. Then modify the Unit cost according.

Hope this helps

Member Avatar for angelmichael4

Hi Lolafuertes,

I have resolved the problem by using the CellBeginEdit_Click Event. Thanks for your response. Was much appreciated.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.