Extract item from a list and compare with another table

[andrea_vellone]

HI, I have a table "order" with a list of item chosen from the table "activity" , many orders contain multiple tasks,
...
ID:1
TASKS: PL123456,PL123457, PL123456
ID:2
TASKS: PIPPO, PIPPA
...
the TASK are taken from a table ref called activity that is something like that:
ID:1
TASK: PL123456
STATUS: CLOSED
ID:2
TASK: PIPPO
STATUS: OPEN

Now, for every Tasks on table Order I need to know if is closed or open...

Any idea?
Thanks a lot
Andrea

[TeeSee1]

One idea...

In the TASK table, create a VC with the following formula and make it the label.

IF(
 [STATUS] = "OPEN", "O",
 "C"
) & ": " & [TASK]

I thought formulas would work but unfortunately they are not reflected in an ENUM column...