Updating an underlying table 
Author Message
 Updating an underlying table

Here is the scenario, running V 7 on Win 98:

These actions take place when the user presses a pushbutton on a form.
The form contains the table "Prospect" and table frame for table
"Status;" in a one-many relationship. Status records actions taken with
respect to the prospects.

Structure, broadly:

Prospect:
Prospect_ID    I    *
Field 2
Field 3, etc.

Status:
ID    I    *
Prospect_ID    I    (secondary index)
Field 3
Field 4, etc.

Now here is the challenge. When the user presses the button, either the
existing record is exported to Winword to be mailmerged into a letter or
that record is added to a "Holding_" table which will later be exported,
etc

When I do individual records, I have incorporated the updating of the
status table by kludging: after exporting the "answer" table (one
record, produced by a query on the button). another button on the form
is pushed with updates the "Status" tableframe (on page two of the
form). This is a kludge, but it works.

My challenge at this point is to write the code for the updating of the
status table for the records that had been added to the "holding_" table
and now need to show that this action (in this case, the sending of a
letter) has taken place. The records that go into the "Holding_" table
have their key as part of the record. I need to add records to Status to
reflect the action taken for those records of Prospect. The Status table
needs to be incremented, a record added, the Prospect_ID field of that
record to reflect the record etc.

I hope someone can help wade through this & give me a hand.



Mon, 10 Jun 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. View don't get updated when underlying table schema changes

2. Detect and forward updates in underlying tables

3. Detect and forward updates in underlying tables

4. How to update an the underlying table of arecordset that is cobstructed from 2 tables

5. Resolution - Re: ADP uses underlying table for UPDATE, INSERT instead of view

6. ADP uses underlying table for UPDATE, INSERT instead of view

7. SQL Server denied updating to View's underlying table

8. ADP uses view's underlying table privs for UPDATE, INSERT

9. How to update underlying recordset in access 2.0 report

10. Databound controls not updating underlying value on SHAPE stmt

11. Update underlying Recordset in Access Report ??

12. Bound Control not updating underlying recordset when clicking close button


 
Powered by phpBB® Forum Software