RES: RI enforcement and m2m relationships.

2004-06-02 Thread Renato Cramer
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

Re: RI enforcement and m2m relationships.

2004-06-02 Thread Jochem van Dieten
[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

Re: RI enforcement and m2m relationships.

2004-06-02 Thread SGreen
<[EMAIL PROTECTED]cc: bsrc.ac.uk> Fax to: Subject: RI enforcement and m2m relationships.

RI enforcement and m2m relationships.

2004-06-02 Thread eifion herbert (IAH-C)
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