This form is for entering charges to a customer (Amount field).  There may be existing charges that will populate the grid.  The intent is not to change the custno but to populate a new row with the custno/subno and agent (name) of the customer to be charged in that row and then assign an charge amount.

You raise a good point that I should set any existing charges entered into the grid to read only / non-editable.

Based on your previous suggestion I disabled editing on the other columns using:

e.Layout.Bands[0].Columns[“var”].CellActivation = Activation.NoEdit;

and just used the events to write those values.

Thanks Mike,

My Manger also had time to work with me on this and he also used an event to populate the rest of the grid.  I thought I was missing something in the data binding that was preventing the grid from being populated. That was a deep rabbit hole unfortunately.

You bring up an interesting point about the data in the drop down but in this business case it is historical data and would not change.  It is worth considering in in other cases though.

I really appreciate the assistance!

Thanks,

Joe

Hi Mike,

Thanks for the quick response.  Multiple drop downs would be bad in this case as it could lead to errors in data entry.  Currently the drop down will only fill the Custno filed.  I want all the data from the selected row to fill all relevant fields  (subno and agent) as well.  See below.

Thanks,

Joe