updating table 2 from table1 in msaccess

[regalla]

dear friends,
i want to update the table2 field which is same as table 1 field in ms accessdatabase.
when ever i enter data in table1, table2 field which is same as table1 field should updated.table1 and table2 are connected to form1, form2 seperately.
i request any body, please let me know the code to transfer data from table1 to table2 and update table2 simultaneosy.

[QVeen72]

Hi,

In "Save" button of First Table, Insert same Data in Second table as well..
Say, if ID is a PK in your first table, and Second table is same structure as first, then after adding(Save) record, you can run an Insert statement like this:

sSQL = "Insert Into Table2 Select * From Table1 Where ID = " & MyID
Conn.Execute sSQL

Same thing you can do when Editted, Delete the Record from table2 and Insert from table1 (Depending on the ID)

REgards
Veena

[anto_nee]

Veena,

Dont we have trigger concept in Access..???

[regalla]

thank you veena

Hi,

In "Save" button of First Table, Insert same Data in Second table as well..
Say, if ID is a PK in your first table, and Second table is same structure as first, then after adding(Save) record, you can run an Insert statement like this:

sSQL = "Insert Into Table2 Select * From Table1 Where ID = " & MyID
Conn.Execute sSQL

Same thing you can do when Editted, Delete the Record from table2 and Insert from table1 (Depending on the ID)

REgards
Veena

[regalla]

thank you veena for your reply

Hi,

In "Save" button of First Table, Insert same Data in Second table as well..
Say, if ID is a PK in your first table, and Second table is same structure as first, then after adding(Save) record, you can run an Insert statement like this:

sSQL = "Insert Into Table2 Select * From Table1 Where ID = " & MyID
Conn.Execute sSQL

Same thing you can do when Editted, Delete the Record from table2 and Insert from table1 (Depending on the ID)

REgards
Veena