Subform query

[dsinclair999]

Hi all,
Another linked subform query and I really don’t have a clue what the problem is this time!
My little database consists of three linked subforms.
Docid, Revision, Distribution
If the Document Number(Docid) is changed, it is not updated in the Distribution table, but the Revision table is updated ok!!!
I've attached the database so you can see the setup and would appreciate any help with it.

Regards
DS

 

[RainLover]

It really would help if all of your Primary Keys were Autonumber.

Composite keys are difficult to handle. I never use them.

Also get rid of your lookups in the tables. These are only to be used in forms. Search The Evils of Lookups. It is a small but good read.

In my signature there is a link to my shy drive. I wrote am article on naming conventions. Suggest that you read that and another one there is on RDMS Principles which is also a good read, but I don't know who wrote it.