John Kaufmann wrote:
In a message dated 2009.04.09 13:32 -0500, Drew Jensen wrote:
That depends on the database you use. As Base itself doesn't care,
the database has the responsibility to do the right.
But that's my question: Base does not seem to care about direction -
but that is the front end to the database. So how does the back end
know what we want?
... But in the relation ships design you can select what should
happen on each side differently. So in your example just define that
when an employee is deleted than his photo should be deleted as well
and when only his photo is deleted the employee stays untouched.
...
At the top of the dialog are two drop down lists under "Tables
Involved" The table in the left drop down is the "referencing table"
and the table
in the right drop down is the "referenced table"
Ah - *that* is what I was missing. I thought it had to be simple, but
just could not find that simple thing in the Help or other
documentation. Thanks! I'm sure Ocke knew that, too, but probably
figured it was something everyone knows. He did not reckon on my
aptitude for obtuseness.
Ah - seems once again I've proven that I don't know when to shut up.
The thing about 1..1 vs 1..(0 or 1) was just me being anal retentive.
LOL - I started typing a 'in my defense' paragraph...think I'll just
shut up instead.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
