By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,609 Members | 1,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,609 IT Pros & Developers. It's quick & easy.

Relationships and Cascading Updates problem

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.