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
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