Skip to Content
0
Former Member
Nov 30, 2009 at 11:03 AM

Display many fields of a lookup table in the main table

65 Views

Hello Experts,

In MDM, I have a "Suppliers" table which is a lookup table. This table has 4 fields :

- Supplier Name (Display Field)

- Supplier Code

- Email

- Phone number

In the main table, a field "Supplier" uses the "Suppliers" lookup table. This fields displays the "Supplier Name" of the "Suppliers" lookup table.

Now I also want to display the "Email" and the "Phone Number" of the supplier. If I set these fields as Display Fields in the "Suppliers" lookup table, they appear concatenated in the main table, which I don't want.

The only way I found to display those fields is to set 2 new fields in the main table as calculated fields, eg: IF(TRUE, Supplier.Email).

Is there any way to display those fields w/o using calculated fields?

Thanks for your help