My scenario is I have an order detail and when purchasing I need to keep every good's expiration and lot number.
My screen:
--------------------
top: text area
user enter material number, expiration and lot number and click add button
--------------------
middle: Grid
master grid -- order detail include material number(key), material name, order quantity.
detail gird -- expiration, lot number, quantity
My problem is how do I find the row that the master grid key and material number that I key in matched? And how do I insert the data into the detail grid instead of manual operation such as select row, expand, and click add button?