I have used SPD to create and ECT to a standard SQL Database, and then a view. In the view there is an ID field, and then another field of a string type that stores codes (consisting mainly of numbers, but some number and letter combinations do exist).
On the ECT I have created a "Read List" operation with a limit filter and a filter to return values based on the code column.
I have setup an InfoPath form that uses the external item picker and uses the ECT. When I test the form and use the second button from the left of the picker, the "Select external item(s)", a pop-up dialog appears and I can search for and select an item just fine.
When I enter a code directly into the external item pickers text box and then click the "Check if external item exists" button it works but instead of then underlining the code (to indicate it was correct) it returns the id of that row and underlines that.
No matter how I try to alter the settings of the external item picker in InfoPath or the ECT in SPD can I get it to work.
Do I have to revert to code and create my own finder method rather than using the out of the box features of SPD to get this to work as I want?
Also, are the names of the filters set in the SPD wizard for creating the "Read List" operation the finder methods I should be referencing in the external item picker properties?