01-24-2014 03:39 AM
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?