
I followed this kb support.microsoft.com/.../846862
But still get this error. The record is there in table PVREC.
Any idea what else need to be done? thanks
*This post is locked for comments
I have the same question (0)I found a solution. Say if you create a separate store procedure to look up values, etc, XSalespersonID_PV, . You need create a new csv file like what shown below. Then use possible value import utility to add this record inot pvrec table. So SQL tracing is your good friend that can found exactly what procedure called and what value is passed.
"XSalespersonID_PV","0831000","","Select * From Salesperson Where SlsperId like @parm1 order by SlsperId","Salesperson","Salesperson.SlsperId;Salesperson ID;117;0","Salesperson.Name;Name;110;0","Salesperson.Phone;Phone;0;0","Salesperson.Zip;Zip;0;0"