Hello,

Hope someone can point me in the right direction with this problem, I'm sure I'm doing something fundamentally wrong.

Having created my database and found everything was working very nicely apart from one really annoying thing. I have four tables on a one to one relationship (one the primary tbl), and two more on a one to many, all linked to the primary table. The common fields are all linked (relationship), and all common fields have an SQL to look up the main table, to avoid having to key enter more than once. RI has been enforced on all the relationships, and the cascade update and delete has been ticked.

Firstly the updates don't cascade, if I change the main table the other tables don't update:mad:

Also the primary key in the main table, and the foreign key in the other tables on the one to one side are all primary keys, as they all have exactly the same records. Perhaps this is knocking it out?

Can anyone point out my error?? Much appreciated and thanks.

Cascade update will only cascade changes from the primary key of the "parent" table to the foreign key in the "child" table.

Pat,

Thanks for the prompt reply. So the primary key is the problem. I will change and see wjat happens.

H