when Richard relates the customer table in a one-to-one relationship with the customer extended table referential integrity is enforced and cascade delete is checked which i understand why but why not do the same for cascade update - is there a specific reason not to apply it or was just left out or not considered important enough to have it apply?
Kevin Robertson
@Reply 4 months ago
Cascade Updates are useful if you use a natural key that may change but following along with Richard's classes, we always use AutoNumbers which can't be changed which is why Richard doesn't use Cascade Updates. He has mentioned this in several classes.
David KennedyOP
@Reply 4 months ago
got you,thanks. I am still kind of new, picking things up slowly as i go along, appreciate you clarifying that small matter. The expert class really starts going into form control details, there is such a myriad of them to learn and get use to but make forms so flexible.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 4.
