Bind data to MS Dynamic CRM sub grid from external database -

i not able set lookup fields on ms crm sub grid external database.

i tried retrieve multiple plugin as:

get data external database in datatable

entitycollection entitycollection= (entitycollection)context.outputparameters["businessentitycollection"]; entity anyentity= new entity("entity");

anyentity.attributes["new_customerid"] = new entityreference("contact", new guid("b26ef3e7-bd68-e411-9447-00155d010b06")); anyentity.attributes["new_address1"] ="value datatable";

entitycollection.entities.add(anyentity);

except lookup type field able bind fields sub grid external database.

this expected since cannot "look up" record in different database. crm enforces foreign key constraints on lookup fields can set lookup value point entity exists in crm system. set lookup value in crm based on value in other database.