Hi,
I created a virtual table to call stored procedure. I also created a calc field SaleSummarydatefromdateto.SoldToTypeID in this table and specified Value Method to call GetSoldToTypeDescr().
In data access script, I have code to GetValueForField as below

loValues = toApplication.DataEngine.GetValuesForField('SaleSummarydatefromdateto.SoldToTypeID', ;
'equals')

When I run my report, filter dialog prompted a textbox with value 'ZERO' (since this is surrogate key) and Values button. I clicked on Values button and it shows Description of all record of my FK table.

1. After I select any value from value popup, textbox is not refreshed.
2. How does stonefieldquery know what surrogate key value to be returned?

Please advice.
Thank you