In App A I have a lookup field in a subform that looks up records in App B, I want to be able to populate another field in the subform based on what the user selects in the lookup field.

I understand that this is possible using a custom function that collects the data and places it in a map, I can then call the function and using the ID of the lookup field use the map to return the variables. I've got so far and have managed to create the function in App B....

string fet_ch(int id)

{

fet = Book_Record[ID == input.id];

map1 = Map();

map1.put("Title",fet.Working_Title);

map1.put("BKCode",fet.Book_Ref);

return map1;

}

However, it's when I get to App A and try and call the map and use the ID to select the data for the field I fall down. I'm not a programmer although my skills are getting better, and zoho support has helped a lot this particular problem is, at the moment beyond me.

I really am stuck on this one