Bill Blancett
|
| Posted: 09/05/2001, 2:36 PM |
|
I have several forms which update the main table but also need to insert new
information from the form to a related table upon submission. For example I
have the applicant table as the main table with applicant_id as the primary
key. The user fills out the form and certain fields in the applicant table
are UPDATED but another related table by applicant_id needs data INSERTED to
it. Is it possible to both update a table and insert data into a table on
the same form ?
|
|
|
 |
David A. Lee
|
| Posted: 09/05/2001, 4:35 PM |
|
Yes, but you need to hand-code this in the "After Insert" and "After Update"
events
> I have several forms which update the main table but also need to insert
new
> information from the form to a related table upon submission. For example
I
> have the applicant table as the main table with applicant_id as the
primary
> key. The user fills out the form and certain fields in the applicant table
> are UPDATED but another related table by applicant_id needs data INSERTED
to
> it. Is it possible to both update a table and insert data into a table on
> the same form ?
>
>
|
|
|
|
Jeff Walters
|
| Posted: 09/06/2001, 3:43 AM |
|
Alternatively
- if you are using a SQL database (rather than Access), you could use a
trigger to achieve the same thing. In terms of robustness, this is the
preferred route in case there are opportunities to insert / update data from
alternative front-ends to your CodeCharge application.
Jeff
"David A. Lee" <dave@calldei.com> wrote in message
news:9n6cs0$qoj$1@news.codecharge.com...
> Yes, but you need to hand-code this in the "After Insert" and "After
Update"
> events
>
> > I have several forms which update the main table but also need to insert
> new
> > information from the form to a related table upon submission. For
example
> I
> > have the applicant table as the main table with applicant_id as the
> primary
> > key. The user fills out the form and certain fields in the applicant
table
> > are UPDATED but another related table by applicant_id needs data
INSERTED
> to
> > it. Is it possible to both update a table and insert data into a table
on
> > the same form ?
> >
> >
>
>
|
|
|
|
|
