Hi all, In a one-to-many relationship, I can easily see how to automatically delete any child records when the corresponding parent record is deleted. But how is this done in reverse? When the final child record of a relationship is deleted, can the parent record automatically be deleted in some way? The example I'm using is an order. When the final detail line of the order is completed (and the record is deleted from the OrderDetail table), I'd like the order header to automatically be deleted from the OrderHeader table.
Thanks very much, John _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
