Help me Guys. Updating a child table, based on changes done in Main table.

[jabes7]

Hello Guys,

I have a Catalog Table which contains several fields.
SOURCE TABLE

ID NAME Username PWD
A john abc a123
B jack xyz b234
A jone def c456

And i have a Sequence table where i generated Sequence for CATLOG ID's.
select distinct id from catalog

SEQUENCE TABLE

Sno ID
1 A
2 B

Now i look up and pull values from both the table into Target Table.
TARGET TABLE

TN SN ID NAME Username PWD
1 1 A john abc a123
2 2 B jack xyz b234
3 1 A jone def c456


Whatever i make a change in Source table record it should be Updated in Target Table.

Both Insert, Update Operations done in Source table should reflect in Target Table.

SQL Query, VBA Code anything Welcomed.. Help Me Guys. Thanks in Advance.

 

[MarkK]

Hey there and welcome to the forum.
In a database the same data should not be stored in more than one place. Your need to copy data from one table to another is evidence of a design problem. Google 'normalization' for more info on how not to repeat data.