Formatted Search in Row

[Former Member]

Hi,

i have a UDF in the PDN1. so i want that, when i change the value of this field i want to change the warehouse of this row, according to the value of the udf.

how can i access one field of the same row?

[Former Member · Accepted solution]

I am doing a similar thing but it involves 2 user-defined fields on a sales order row.

First I created the query that will be used as the formatted search as

"SELECT $[rdr1.U_XXDENDUS]" Note there is no "FROM" clause. This will return the value in the UDF field on the matrix row being maintained by the user.

Then I assign this formatted search to my other UDF (for you it will be the warehouse) by presssing Alt-Shift-F2. Click search by saved query, then give it the name of the FS, or double click on the line for it to select from the list.

Then click auto-refresh and also chose "when exiting altered column" from the first combobox and then select your UDF from the second combo box. This CB will display a list of the field descriptions, so don't be looking for "U_". I also check the "Refresh Regularly" radio button.

Whenever the user enters a value in my first UDF (xxdendus) and tabs out of it, my second UDF (the one with the FS assigned to it) is automatically updated.