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.


Reply via email to