Copying fields to another table

[donishere]

[b]TABLE 1[/b]
ID  BADGE       FIRST   LAST
16	408-00-0025	JOHN	GARRETT
17	408-00-0027	KEITH	WELTER
18	408-00-0028	KRIS	HUDECK

[b]TABLE 2[/b]
ID  BADGE       SCORE
?   408-00-0025 85
?   408-00-0027 89
?   408-00-0025 80
?   408-00-0025 75
?   408-00-0028 93
?   408-00-0027 99
?   408-00-0027 79
?   408-00-0027 84

I am adding an ID field to both tables and making it the primary key for TABLE 1 so the two tables can have a relationship. Is there an automated way to copy the appropriate ID values for each Badge value from Table 1 to Table 2?

(btw, this is in MS Access)

Thanks a bunch.

 

[bborissov]

UPDATE Table2 SET Id = Table1.ID WHERE Table2.Badge = Table1.Badge

Borislav Borissov

 

[rmnastor]

why can't u just relate them on the BADGE field