Orderform: Matrix UDF's through databinds

SeKo

Hi All,



a customer of ours would like to have the UDF's of the RDR1 table more visible on the form. So we've narrowed the grid and would like to have 3-4 textedit fields next to the grid with the values of the UDF's for the selected row. Is there any chance I can do this with a databind to the RDR1 table? This doesn't seem to work, but maybe I'm doing something wrong..



If I do it manually and add a click event to the matrix, I can go get the values and set them in the textfields, but this means the original field that was selected gets deselected. How can I found out which field (or if it's in the matrix, which cell) was selected, so I can select it after setting those values?



Thanks!



Sebastiaan

Michael Egloff

Hello Sebastiaan,



if the row is selected (highlighted) than you can read out this row number with the property "SelectedRows" on the rows of the matrix.

SeKo

Hi Michael,



that part is working, but the problem is if I show these values in a different TextEdit field with field.Value= "value of UDF in selected row", the focus jumps to that field, and he does it every time I click on a field in the matrix, so it's impossible to change any values in the matrix...

Michael Egloff

Hi Sebastiaan,

so you want so select the matrix row at the end again? Or is the reading of the values in the matrix the problem?

Maybe you can save the current row of the values displayed in a global variable (extended code) and use it later on to update the values in the matrix?

SeKo

Hi Michael,



On the Order form I have several lines. If I want to change the price of a line, I select the box in the line, but since the line is selected, he changes the values of the UDF fields which I show next to the matrix, and puts the focus there. So every time I want to change a value in the matrix, the focus jumps to the TextEdit fields. So it's impossible to change any values since the focus always jumps.



I could check which cell is selected, and put the focus back there, but that seems a bit cumbersome. A Databind would be much nicer, but that doesn't work on a row level if I'm correct.