Formatted Search and drop down box

[Former Member]

I have a UDF for an Internal Sales Person (ISE) on the CRD1 table that I pull to the Sales Order through a formatted search.

There are times we want to override that UDF and I wanted to have a drop down field to allow it to happen. When I added the valid fields the formatted search no longer works.

I am pulling in from the OSLP the name to populate the ISE on the CRD1. Is there a way to modify the query to allow it to be over ridden using the OSLP as well.

Here is my query now.

SELECT U_ISEName FROM CRD1 where CardCode = $[$4.0.0] and Address=$[$40.0.0]

Appreciate any help in finding away to do this

Thanks

Steve

[Former Member]

Hi Steve,

You can have either a list or a mapped value. However, they cannot be available in the same time. Which one you need more.

Thanks,

Gordon