Skip to Content
0
Former Member
May 13, 2010 at 05:31 PM

Formatted search in contacts

26 Views

On the Business Partner I have created several fields that I would like to automatically update with data from a Sales Person Region table we have created.

The concept is in the Sales Rep # field(U_SalesRep) I have a query that presents the table and the user selects the number by clicking on it. This part is working as planned.

Where I am struggling is trying to use that value to get the name from the same table.

Here is the query that I built.

SELECT T0.[U_BPName] FROM @SLS_PERSON_REGION WHERE $[$U_SalesRep.0.0] = T0.[U_SlsPerNum]

Any help would be appreciated.

Thanks