Lookup from multiple tables

Dynamics 365 for Finance and Operations/AX Technical Forum
1

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

2

You can refer the following link:

http://kashperuk.blogspot.com/2008/09/sysmultitableloookup-dynamic-lookups.html

3

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