I have a form named app_bndown_add_frm, which I can add, update and delete records from. When I add, update or delete a record, I need to send it to three different tables. In the current form, it is referencing the Application_files table which has the following column names:
APP_FILE_ID (PK)
APP_NAME
CLASS
SYSTEM
ENVIRONMENT
ACCESS_SELECT
ACCESS_INSERT
ACCESS_UPDATE
ACCESS_DELETE
If anything is added, deleted, changed it needs to go to these tables.
TRANS_REF TABLE
TRANS_REF_ID
TRANS_INQ_FORM
TRANS_UPD_FORM (need actual form name here)
TRANS_TIMESTAMP
BINDOWNR_NAME
APP_FILE_NAME
PLAN_NAME
TCODE_PGM_NAME
DB2_NODES_COLLID
RACF_GROUP_NM
AUDROW TABLE
AUDROW_ID (PRIMARY KEY OF TABLE NAME)
TRANS_REF_ID (PK)(FK)
TABLE_NAME (PK)
AUDFIELD
AUDROW_ID (PK)(FK)
TRANS_REF_ID (PK)(FK)
TABLE_NAME (PK)(FK)
COLUMN_NAME (PK)
PREVIOUS_FIELD_VALUE
UPDATED_FIELD_VALUE
How do I write code to send the information to these table.
I have no idea how to accomplish this.
Please help.
Thanks
Nettie205
APP_FILE_ID (PK)
APP_NAME
CLASS
SYSTEM
ENVIRONMENT
ACCESS_SELECT
ACCESS_INSERT
ACCESS_UPDATE
ACCESS_DELETE
If anything is added, deleted, changed it needs to go to these tables.
TRANS_REF TABLE
TRANS_REF_ID
TRANS_INQ_FORM
TRANS_UPD_FORM (need actual form name here)
TRANS_TIMESTAMP
BINDOWNR_NAME
APP_FILE_NAME
PLAN_NAME
TCODE_PGM_NAME
DB2_NODES_COLLID
RACF_GROUP_NM
AUDROW TABLE
AUDROW_ID (PRIMARY KEY OF TABLE NAME)
TRANS_REF_ID (PK)(FK)
TABLE_NAME (PK)
AUDFIELD
AUDROW_ID (PK)(FK)
TRANS_REF_ID (PK)(FK)
TABLE_NAME (PK)(FK)
COLUMN_NAME (PK)
PREVIOUS_FIELD_VALUE
UPDATED_FIELD_VALUE
How do I write code to send the information to these table.
I have no idea how to accomplish this.
Please help.
Thanks
Nettie205