Skip to Content
avatar image
Former Member

Display many fields of a lookup table in the main table

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 30, 2009 at 12:30 PM

    Hi Patrick,

    you already found the master way. I do not think there is any other way of doing this. Even though this is not so great, as calculated fields do not update at once, whenever a change occurs.

    However, if you use the portal for displaying the data, you could create a second item details iview for suppliers that is triggered by eventing. Then you would have all supplier information in single fields.

    Is there any specific reason why displaying all concatenated information in one field is not sufficient?

    Best regards

    Christian

    Add comment
    10|10000 characters needed characters exceeded