Hello all

I have four tables:
LOGIT_WLO (id integer, logit_status integer ...)
LOGIT_ORDER (id integer, logit_wlo_id integer -> references LOGIT_WLO ...)
LOGIT_REEL (id integer, reel_code integer, srv char(3), logit_order_id ->
references LOGIT_ORDER ...)
LOGIT_SCR_ITEM (id, reel_code integer, srv char(3) [both fields reference
LOGIT_REEL], status ...)

due some computations field 'logit_status' in table LOGIT_WLO changes its value.

Is it possible to change the 'status' field in LOGIT_SCR_ITEM in single update
statement called from after_update trigger of LOGIT_WLO table like :

UPDATE LOGIT_SCR_ITEM SCR
SET SCR.STATUS = 1
WHERE ??????

it would be simple when only one field from LOGIT_SCR_ITEM table references
LOGIT_REEL table, but what is the condition when there are more than one field
like in the example above.

TIA
Marcin