On Tue, 7 Aug 2007 15:00:02 -0700, dee wrote:

If the human beings responsible for input of the question number, etc. that
will be the PK make a mistake, it will be difficult to update.

If, however, an autonumber is used for the PK, then the change can be made
and cascading to all related tables.

You have it backwards.

Cascade Update is completely useless for an Autonumber, since an Autonumber
field cannot be edited. If instead you use a Text field as the PK, it *can* be
edited and cascade updates will take care of the related tables.

John W. Vinson [MVP]