Forms question

From: Krishna Subramanian <krishnas_at_mailings.com>
Date: Mon, 28 Sep 1998 12:33:37 -0500
Message-ID: <6uohgn$2fc$1_at_ffx2nh2.uu.net>



I have a problem relating to creating new records.

Consider a form having several blocks - A, B, C, D, etc. Table A has a one to many relationship with B and a similar relationship with C. B and C have each a one to many relationship with D. D has a one to many relationship with E.
Each table has an ID (except for table A which has two IDs) that serves as its primary key. The IDs are automatically generated.
What would be the best way of ensuring that a new record is created in D ane E
if a new record is inserted in either B or C. Specifically, what triggers need to be created.

Thanks.
KMS Received on Mon Sep 28 1998 - 19:33:37 CEST

Original text of this message