Referential Integrity: Cascade Update not working as expected???

[isetea]

Hi,
I have a database with a couple of tables. The primary table has a primary key called "StaffNo". I checked the relationships between the primary table and each related table, if I have ticked on the boxes for referential integrity, cascade updates. All done. If I now create a query, which selects the primary table and one related table and enter a new StaffNo, I would expect to see the new StaffNo not only in the primary table but also in the related one. But there is nothing. Do I expect wrong? Have I missed sth.? I read a few posts in this and other forums reg. referential integrity, but I have no clue, what's wrong.
Any quick help is much appreciated.
Thanks

 

[gemma-the-husky]

There's bothing wrong.

If you add a new record in the primary table, at that point there are no linked records in the secondary table, so nothing to cascade.

I think what it means is that if you change a PK in the primary table (which you can't do if its autonumber) then all records in the secondary table with the existing PK, set as their FK, will also be updated to reflect the change.