Relationships and Cascading Updates problem

[Roger]

Subset of Database Tables/Fields are as follows:
Table1 Field1 and Field2 values can occur multiple times in the table
Table2 Field1 has a unique value in the table
Table3 Field1 and Field2 when combined have a unique value

Table1 Field1 and Field2 not indexed
Table2 Field1 indexed - unique values
Table3 Field1 and Field2 multiple field index - unique values

Relationships defined as follows:
Table1 Field1 many-to-one join to Table2 Field1
Table1 Field1 many-to-one join to Table3 Field1
Table1 Field2 many-to-one join to Table3 Field2
Table2 Field1 one-to-many join to Table3 Field1

Objective is to cascade updates through all three tables but this
configuration does not allow Field1 to be updated from any table. Field2
changes cascade correctly from Table3 to Table1.

Any ideas how I can get all fields to cascade updates correctly? TIA

Roger

[Roger]

The problem is the extra many-to-one join. When I
removed the join between Table1.Field1 and Table2.Field1 the cascading
updates appear to work correctly with both Field1 and Field2.
It seems that the Field1 updates are now cascading from Table2 to Table3
then on to Table1.
Apparently works OK now.

Roger