....please.
I've found other posts that explain the Cascade options, but the
Enforce relationships option still is foggy to me.
As to "enforcing relationship for ... UPDATEs"(with cascade NOT
checked), then I'm guessing that an update to that key field that would
normally cascade will instead produce some sort of constraint violation
error?
And if Cascade updates is checked, but I try to update a key in a table
on the many side of a relationship, then this won't cascade "up" to the
one side will it? Would it just produce a constraint violation?
With enforce relationship for insert:
Does this mean if I try to insert into the many side of a relationship
that I can't insert unless the keys that are related already exist in
the other table?
How does this apply to a one-to-one relationship? If I can't insert
into one table because the key isn't in the other one, how do I insert
the record with that key into both tables simultaniously? I'm sure I'm
wrong about some of my guesses here.
Thanks in advance.