Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Astute Commentator
Posts: 6
Registered: ‎10-29-2009

Problem using a SQL view with a Lookup

I'm trying to use an entity created from a SQL view to populate a lookup control, however the lookup is not returning any data.


I created the view, enabled it in DB Manager and succesfully created an entity for the view.  I verified that the keyfield value in resynctabledefs is populated and also set the String Expression for the entity. The Lookup control  is set with a lookup binding mode of "String", and the lookup entity name is set as the new entity.  


In the client, when I open the lookup, it returns no data.  The underlying view definitely does contain data, so I'm not sure what I've done wrong.  Is there a step I may have missed in setting up the entity?




[SalesLogix 7.5.4]

Jason Buss - Customer FX Corporation / Application Developer
| |