I have a ERP system which is linked to SharePoint via BCS. In a previous 2007 site, the BDC layer used the searchcode from the ERP system as primary key. That meant the user could just type in a searchcode in the textbox; hit the resolve button and then the matching customer would be automatically selected.
Now in the new situation in SharePoint 2010, BCS isn't using the search code any more because that code wasn't truely unique which caused problems. So now we're using the true primary key, which is an integer, but users don't know that code by heart. So instead of typing in the code and hitting resolve, they now need to open up the BCS picker, select the searchcode filter, type the name, hit search, select an entity.
Much more steps to get to the same end result, and my users aren't pleased with that. So I'm looking for ways to optimize this, without having to go back to using the searchcode as PK again. Can I, for instance, provide a default selection for the BCS filter, so it's default set to 'searchcode'?