Referential Integrity with soft deletes

[Rob Berendt <rob@xxxxxxxxx>]

Suppose that you have a master file with an active record code.  
The business rule is the following:  Existing records in children 
files may contain inactive master records.  However, no new children 
files may contain inactive records from master files.  Is there a 
way to enforce this using RI?

Sample master:
Rec
Cod  Key
 A   A
 D   B
 A   C
 A   D
 D   E

Child file
Child   Master
 Key     Key
  1       A
  2       A
  3       B
  8       A
  9       D
 10       E

If we change the RecCod on D to A then we could not add a new child, 
say 11, that uses masterkey of D.  Is this possible?
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---