C
Chris Harmon
I am new to access and I can catch on to things pretty quickly so here
is a simple idea of what I want to do but on a muchhhhh larger scale.
I need to take data from table2(new and updated) and combine it with
table1(old database).
Table 1
ID Label
1 a
2 b
3
4 d
6 f
Table 2
ID Label
1 a
2 b
3 c
4 d
5 e
Final Product (table 1 updated)
Table 1
ID Label
1 a
2 b
3 c
4 d
5 e
6 f
In other words Table 1 will be my database. Table 2 will be in the
same format. Sometimes with the same id's with updated(not
duplicated) labels sometimes with new ID's that need to be added.
**If an ID exist in both tables update the information in table1 with
table2 data for that ID.
**If table 2 contains a new ID, Add it to the table1 database
is a simple idea of what I want to do but on a muchhhhh larger scale.
I need to take data from table2(new and updated) and combine it with
table1(old database).
Table 1
ID Label
1 a
2 b
3
4 d
6 f
Table 2
ID Label
1 a
2 b
3 c
4 d
5 e
Final Product (table 1 updated)
Table 1
ID Label
1 a
2 b
3 c
4 d
5 e
6 f
In other words Table 1 will be my database. Table 2 will be in the
same format. Sometimes with the same id's with updated(not
duplicated) labels sometimes with new ID's that need to be added.
**If an ID exist in both tables update the information in table1 with
table2 data for that ID.
**If table 2 contains a new ID, Add it to the table1 database