update and position trouble

[burtonray]

In my Details gridview of my Order, I am using a dropdown showing ProductsID list from my Products table. I can get it to work, but not as I think it should. I have two problems, 1. I want to have the ProductName and UnitPrice (these columns are in both tables) to follow the position of the ProductsID box as it changes, then saves the selected value to that row when it moves to the next row 2. The ProductID dropdown does not respond initially when clicked or tabbed, it must be clicked at least twice. I am using techniques from the “forms over data” videos but I couldn’t find, or don’t understand, how to make the one to many relationship of my Details and Products tables do what I need

 

[burtonray]

I need to know, is this so incredibly stupid that no one will bother with it, or is it clear off in left field and no one will try to tackle it? Anyone please let me know.