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.
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