Para: eifion herbert (IAH-C)
Cc: [EMAIL PROTECTED]
Assunto: RI enforcement and m2m relationships.
Hi all,
I'm developing a database to store job adverts to appear on a company
website.
Each vacancy has at least one supervisor, but may have more than one,
and a supervisor may be responsibl
[EMAIL PROTECTED] wrote:
I don't see how you can possibly hope to satisfy two mutually dependent
constraints at the exact same time. It's a chicken-and-egg scenario. If you
can't create your vacancy record first (to get its PK value) you won't be
able to create the new record in your supervision ta
<[EMAIL PROTECTED]cc:
bsrc.ac.uk> Fax to:
Subject: RI enforcement and m2m
relationships.
Hi all,
I'm developing a database to store job adverts to appear on a company
website.
Each vacancy has at least one supervisor, but may have more than one,
and a supervisor may be responsible for multiple vacancies.
I've resolved the vacancy<-->supervisor many-to-many relationship in the
normal