Hi everyone Does anyone know how to display the data from more than one table in a lookup. In Dynamics 2009, they've done a lot of normalizing.
EmplTable used to have an EmplId field AND a Name field The Name field has been moved to a table called DirPartyTable now. EmplTable and DirPartyTable linked on a field called PartyId. The thing is, when i used to write lookups out of EmplTable, they used to look like this SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(EmplTable), this); ; sysTableLookup.addLookupField(fieldnum(EmplTable, EmplId)); sysTableLookup.addLookupField(fieldnum(EmplTable, Name)); Now that the Name field doesn't exist in EmplTable, this doesn't work anymore. I'd love to be able to do something like SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(EmplTable), this); ; sysTableLookup.addLookupField(fieldnum(EmplTable, EmplId)); sysTableLookup.addLookupField(fieldnum(DirPartyTable, Name)); But that obviously won't work. Has anyone got any ideas or answers about this problem. Thank you.

