Lookup from multiple tables

Hi to all,

In a form i have stringedit field to which i need to add fields Itemid, transtype,custvendac from InventTrans

and name from custtable

i have overridden the lookup method and used systablelookup but its not working please help me.

can this be done using sysmultitablelookup? can anybody put up the code.

thanks in advance

You can refer the following link:


Thanks i went through that link but i was not able to get the solution . In inventtrans we have a relation for transtype and custvendac == accountnum so now i want the name field from custtable and itemid, transtype, custvendac from Inventrans