Skip to Content
0
Former Member
Dec 09, 2009 at 10:57 AM

Update fields of the main table regarding a lookup table

77 Views

Hello experts,

I have a requirement which is to display several data of a lookup table in the main table.

Those data must be displayed in different fields. Eg:

Lookup table

Supplier Name (Display Field)

Supplier Code

Email

Phone Number

Available Cities for intervention

Main table

Supplier Name

Supplier Code

Available Cities for intervention

To do this, I have 2 solutions:

1. Supplier Code and Available Cities are calculated fields. The issue is that in this case, when I modify the lookup table, data of the main table are not updated.

==> Is there any mean to force this update?

2. Supplier Code and Available Cities are assigned via an assignment expression which is scheduled via a workflow. My issue here is that I would like that when the lookup table is updated, the main table get updated too. For this I wanted to launch a workflow in the main table once the lookup table was modified.

==> Is there any mean to set such workflows?

Those needs don't seem to be such huge? If you have any clue...

Thanks,

Patrick