Subject | |
---|---|
Author | slsolutions2002 |
Post date | 2002-03-07T07:52:55Z |
Hello:
I have an application that adds a number of support records to a
support table when a record is inserted into the main table. These
tables are linked via master/detail. The support records are added
using a stored procedure and a after insert trigger. All this works
fine. On my form I have a grid that displays the support records. I
would like to be able to insert a record into the main table and have
the ability to immediately see the added support records in the grid
and edit them as needed before posting the insert. I can't seem to
make this happen. It appears I have to post the insert before the
support records are added. This causes me to have to add and post
the record to the main table then edit the record to make changes to
the added support records. I would like to do this in one step. Is
there a way to make this happen ?
Thanks
I have an application that adds a number of support records to a
support table when a record is inserted into the main table. These
tables are linked via master/detail. The support records are added
using a stored procedure and a after insert trigger. All this works
fine. On my form I have a grid that displays the support records. I
would like to be able to insert a record into the main table and have
the ability to immediately see the added support records in the grid
and edit them as needed before posting the insert. I can't seem to
make this happen. It appears I have to post the insert before the
support records are added. This causes me to have to add and post
the record to the main table then edit the record to make changes to
the added support records. I would like to do this in one step. Is
there a way to make this happen ?
Thanks