"Rick Brandt" wrote in
:
Howard Maidman wrote:
I too am using AutoNo. as primary key and cannot even get this to
populate itself in a subtable of a one-to-many even though I have
successfully created an accepted ref integrety with cascading
updates etc!
Anybody got any ideas?
What do you mean by "populate itself"? Cascade update updates
*existing* children records when the key field of the parent is
updated.
Except with an Autonumber, the parent value can never change
(Autonumbers are, by definition, not editable), so there's reason to
ever use CASCADE UPDATE on a relationship where the parent side is
an Autonumber PK.
--
David W. Fenton
http://www.dfenton.com/
usenet at dfenton dot com
http://www.dfenton.com/DFA/