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